sum in a report

G

Guest

I have a report and in the footer I have an unbound field that has
=Sum[Cash_Amount]
I have also tried =Sum(Nz([Cash_Amount],0))
So my problem is this report may not have any information in it. If that is
the case then I want the result to be $0.00 right now it comes up blank.
The reason there would be no information is because of my query. The result
are comming back with nothing. Do you know a trick that might help me.
Thanks
Chey
 
J

JK

Chey,

In the Format property of the calculated filed provide 0 for null value eg:

#,##0.00; (#,##0.00); 0.00;0.00

Regards/JK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex Question 1
null 8
Running sum on report 4
Totaling An Aggregate Expression On A Report 4
Sum in report 6
Wrong Sum in Report Footer 2
Filtering report by unbound sum field in group footer 7
Sum Query With Parameters 5

Top