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

       

      Regards,

      Somok