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...
DanaDana's avatar
DanaDana
Qrew Cadet
8 years ago
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's avatar
    MichaelBarrow
    Qrew Cadet
    8 years ago
    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.
  • DanaDana's avatar
    DanaDana
    Qrew Cadet
    8 years ago
    This is my problem- I don't have the data separated into a parent/child relationship. I have everything rolling up to one table. It looks like I'll need to separate it into two tables to do what I need. Thank you Michael!