Skip to main content
Question

Totalling Relationship Total Fields


Forum|alt.badge.img+8
Hello:

I am trying to create a Grand Total Field.   The goal is to total several relationship total fields (all existing in the Work Order Table. 

Playing with the formula, I can get one or two fields to total, but not always.
I am guessing it h as something to do with records having null values in those fields?

Just stuck after several hours of struggling (trying not to pester).

Thank you,

Dirk


[Total Labor Cost]+[Total Materials Cost]+[Total Materials Mark-up]+[Total Equipment Fee]+[Total Sub Contractor Price]+[Total Sub Contractor Mark-up]


Look at each of the summary fields and ensure the checkbox is set to 

Treat blank values as "0" in calculations

Forum|alt.badge.img+8
  • Author
  • Registered
  • March 11, 2019
That was it!

Thank you

Dirk