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

    LOD total mismatch when collapsing rows

    Matt Wilson



      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.