4 Replies Latest reply on Aug 17, 2018 9:20 AM by Hari Ankem

    Work around for Grand total formula inconsistency

    Abhaas Mohan

      Hi all,

       

      This is a query similar to what's been noted and asked around, but I didn't find a working answer.

       

      Basically, my measure formula goes like - [Gap for X] = MAX( [Y productivity],[Z Productivity] )-[X Productivity]

       

      This works fine for all the row dimensions. However, when the grand total doesn't return accurate values.

       

       

       

      In West Champaran, 163-247 = -84 is correct

      In Total, ideally how I'd like it to work is Max(204,158)- 67 = 137. However, we have 171.

       

      Any help welcome!

       

      PFA attached workbook.