Forum Discussion

ZuzanaK's avatar
ZuzanaK
Frequent Visitor
3 years ago
Solved

% Movement

Hello,   I am trying to create a % movement year on year as on the table below.     The formula from the table is 37% in 2022 is (283-207)/207 = 37% I have created one measure as below cl...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, ZuzanaK 

     

    You can try the following methods. [client_count_current] and [client_count_prev_yr] are measures.

    %Movement_client = DIVIDE( [client_count_current]-[client_count_prev_yr],[client_count_prev_yr])

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, ZuzanaK 

 

You can try the following methods. [client_count_current] and [client_count_prev_yr] are measures.

%Movement_client = DIVIDE( [client_count_current]-[client_count_prev_yr],[client_count_prev_yr])

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ZuzanaK's avatar
    ZuzanaK
    Frequent Visitor
    3 years ago

    Hello, 

     

    I have used that formula but it still showed the same error. I have changed the source for year and then it worked. 

     

    Thanks, 

    Zuzana