Forum Discussion

DirkRuana's avatar
DirkRuana
Qrew Captain
5 years ago

Total Revenue Formula

Greetings.

I have a small issue with a formula.

The fields (indicated below) do not total if there is a null value in the the [Total Equipment Price] field.

If you look at image file attached, they do not total left to right.

I know this is probably a basic issue, but I just can't figure it out.

Help is appreciated.

Dirk


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

------------------------------
Dirk Ruana
------------------------------
  • Hi Dirk,

    In all of those fields' settings, do you have the box checked that says "Treat blank values as 0 in calculations?" 


    ------------------------------
    Steve
    ------------------------------
    • DirkRuana's avatar
      DirkRuana
      Qrew Captain
      Steve:

      That did the trick. 

      Thank you so much!

      Dirk

      ------------------------------
      Dirk Ruana
      ------------------------------