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)
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.