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.