Sub total is not working.

[#1]

Sub total is not working.

[qv_jagan]

Hi Pragnya,

Please use this.

Sum(iF(INPUTAMT=0,AMT,INPUTAMT))

Thanks,

Jagan. V

[jagan]

Hi,

Try like this in script

LOAD *

     iF(INPUTAMT=0,AMT,INPUTAMT) AS NewField

FROM

(biff, embedded labels, table is Sheet1$);

Now in front end you simply use Sum(NewField).

Hope this helps you.

Regards,

Jagan.

[ecolomer]

Here you have my proposal