Forum Discussion
DanaDana
Qrew Cadet
I checked my fields and they were both selected to "Treat blank values as "0" in calculations". I've tried different formulas and it seems like only straight calculations work, addition/subtraction/etc.
MichaelBarrow
7 years agoQrew Cadet
Make sure you check that setting both on the original source fields in the child table and also in your summary fields at the parent level. I would check them on in all 4 locations. Is your formula an actual formula field in the parent table or are you doing it on the fly in the report? As Mark says, don't try to do the latter in a summary report. Create the actual formula numeric field in the parent table and then reference that in the report.