Summary Report not providing total
I think this might be the problem: I am using fields with a formula - All of the REV. fields are formula fields. They are totaling correctly. However, the "TOTAL FOR CK DATE" field is not totaling....
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTypically that will happen if the formula for any of your REV fields allows any of the resulting calculations to calculate to null (blank). So the proper fix is to adjust those calculated fields to calculate to zero as a last resort in the IF statement. This can also happen if these [Rev...] fields depend on summary fields where you have not set the "Treat blank as zero" to checked.
The untidy way (imho) is to do this in your [TOTAL FOR CK DATE]
Nz([Rev field 1]) + Nz([Rev field 2]) ...... + Nz([Rev field last])
The Nz() function tells the system to use zero if the value is null (blank). I try to avoid cluttering up the whole app with Nz()s in the formuals preferring to fix them properly at the source.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The untidy way (imho) is to do this in your [TOTAL FOR CK DATE]
Nz([Rev field 1]) + Nz([Rev field 2]) ...... + Nz([Rev field last])
The Nz() function tells the system to use zero if the value is null (blank). I try to avoid cluttering up the whole app with Nz()s in the formuals preferring to fix them properly at the source.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks...I went through and added the Nz to all involved fields. it works now!
------------------------------
Lynne8817 Lynne8817
------------------------------
