Forum Discussion

agd50's avatar
agd50
Icon for Helper V rankHelper V
3 years ago
Solved

Attrition Rate not right

Would anyone have a clue why the calculator and the card aren't matching? They should be the same I think.

 

  • Hi,

    Not sure what is the relation between your table (Seperation and _workForce...),

    But the 2240.74 is the Averag amoun, not sum one. 
    Please change the Sum code to Average and see if it is works:
    I tried to make a dummy data for myself (in one table) and developed the Measure on it :

    Appreciate your Kudos and please mark it as a solution if it helps you.

2 Replies

  • MahyarTF's avatar
    MahyarTF
    Icon for Memorable Member rankMemorable Member

    Hi,

    Not sure what is the relation between your table (Seperation and _workForce...),

    But the 2240.74 is the Averag amoun, not sum one. 
    Please change the Sum code to Average and see if it is works:
    I tried to make a dummy data for myself (in one table) and developed the Measure on it :

    Appreciate your Kudos and please mark it as a solution if it helps you.

    • agd50's avatar
      agd50
      Icon for Helper V rankHelper V

      Wow nice one, I'll test it out