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
Could there be another reason why a currency column isn't totaling? I have the formula below, and it totals in my report. But when I create a summary field against it in a related table, it does not total in reports.
I made sure that all fields being referenced are the same type (currency) and have this checked: Treat blank values as "0" in calculations.
------------------------------
Samantha Sand
------------------------------
I made sure that all fields being referenced are the same type (currency) and have this checked: Treat blank values as "0" in calculations.
Case([Pricing Type],"Bid", Nz([Original Bid Amount]), "Budget", Nz([Budget Amount]), 0)
------------------------------
Samantha Sand
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendIs that Summary field set to show totals?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- It is!
------------------------------
Samantha Sand
------------------------------- MarkShnier__YouCan I see a screen shot showing where it does not total?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Samantha Sand
------------------------------