Forum Discussion

DanaDana's avatar
DanaDana
Qrew Cadet
8 years ago

IF Statement in a Calculated Column in a Summary Report

I have a table named "Validations". Within that table, I have two record types, "Budget" and "Validated". My form has a "Budget Units" field and a "Validated Units" field. I am trying to create a Summ...
MichaelBarrow's avatar
MichaelBarrow
Qrew Cadet
8 years ago
When I have run into trouble with this kind of thing in the past, it has always been around the difference between 0 and null in the comparison. Go into your [Validated] and [Budget] fields and make sure that the checkbox field property for "Treat blank values as "0" in calculations" is checked on. See if that might work.