sum not working

[#1]

Dear all I am using

1. sum(column(1)) but it is not working

2. sum(              ( ( sum( if( trnType='Sales',fld1)) - sum(if(trnType='Sales',fld2)) ) / sum(if(trnType='Sales',fld3)) )  )

this is giving syntex error

don't understand what I am doing wrong in both case

please help

Thanks & Regards

bb

[SunilChauhan]

try this

sum(aggr(column(1),keyfield))

sum(         aggr(     ( ( sum( if( trnType='Sales',fld1)) - sum(if(trnType='Sales',fld2)) ) / sum(if(trnType='Sales',fld3)) ) ,keyfield) )

[#3]

hi, Sunil

thanks for quick reply, but it is not qiving any result

I am trying case 1

a. sum(aggr(column1),unit1,partyName)

b. aggr(sum(column(1)),unit1,partyName)

both is not giving any result

bb

[SunilChauhan]

can u share the sample