2 Replies Latest reply on Jan 9, 2018 7:23 AM by arvindgarg

    LOD calculation error

    Somok Sarkar

      Dear All,

      I need some assistance regarding the following. We have ahierarchical data.

      Sales manager zone, State, Region, HQ name (HQ is the lowest grain and sales manager zone is the highest  grain).


      I have a calculated field named Productivity.

      The formula is Sum(sales)/number of reps by HQ


      Till HQ level the calculation seems to work. However when I am using Region/ any other higher level its not working.


      Eg. for Region = "chandigarh"

      Net sales = 3744001.91

      reps: 27 (for all the HQ within Chandigarh)

      productivity= 138666.7374