3 Replies Latest reply on Aug 6, 2018 9:27 AM by Matt Wilson

    LOD total mismatch when collapsing rows

    Matt Wilson

      Hi,

       

      I have a worksheet that displays the following.

       

      [Total Build Budget], [JTD Cost], and [Commited Cost] are static fields and [Cost_to_Complete] is a calculated field with the following formula:

       

      Once I collapse the Tjob, the Cost_to_Complete column caluclates off the grand total column instead of calculating as a sum. I need the totals at the expanded level, and collapsed level to be 7,258.