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!

      Soham