Hi Team, I am looking the short way to generate a query to count and sum of fields with nom-zero value, from a table named RETURN with the following structure:

Return_Id, Fld_001, Fld_002, Fld_003,.., Fld_200 (All Fld's are variables currency type)

**Result:**

FldName Qty Sum

======= =============== ===========

Fld_001 Count(Fld_001 > 0) Sum(Fld_001)

Fld_002 Count(Fld_001 > 0) Sum(Fld_001)

……….

Fld_200 Count(Fld_200 > 0) Sum(Fld_200)

Basically, I want to avoid manual encoding of a long query.

I appreciate your help, ALF.