summary calculations

[lipin]

I have a text box 'TEXT52' on a report. THis is a calc. textbox here is what is in the control source:
=IIf([Net]>0,[Net])

this works fine.

so in the footer I want to sum any numbers in this column so I put a textbox in footer with this in control source:
=Sum(IIf([Net]>0,[Net])

but it doesn't work so what am I doing wrong

also tried: =sum([text52]) but no good.

Any suggestions?

 

[llkhoutx]

You need to group your data to sum in the footer. Therefore, add a group footer and sum there.