6 Replies Latest reply on Nov 28, 2018 10:42 AM by Deepak Rai

    Confusing Total Cost Calculation

    Mike Ade

      Hi All - I am getting a little confused by my "Total Cost" calculation as the grand total value is correct but where one of my columns has a zero dollar amount the total cost for that column defaults to zero. So for example total cost for first row below should be 2.5k but its coming up as zero. I know its a simple fix and would appreciate your assistance.

       

      Total Calculation: ifnull(SUM([Labor Cost])+Sum([Material Cost])+Sum([Service Cost]),0)