1 Reply Latest reply on Dec 4, 2018 3:41 AM by Zhouyi Zhang

    Defining the behavior of AuM/HeadCount kind of measures

    Soham Das

      Hello Folks,


      If you notice carefully, measures like Asset Under Management/ Account Balance/Headcount all follow a very typical behavior, unlike most other values. They are:


      1. These kind of metrics are not summable across periods

      2. These kind of metrics are summable in the same period

      3. For any given period, there are two values- beginning amount and ending amount.

      4. Beginning Amount of one period is the Ending Amount of the previous period.


      Is there a particular easy way to incorporate these features in one measure? Or do we have to define this behavior individually for the given context using formulas.



      Thank you!