Forum Discussion

bilalkhokar73's avatar
bilalkhokar73
Helper IV
5 years ago
Solved

% Growth with minus Issue

I have to calculate growth vs Degrowth %
My current formula is -

20Vs1021% = DIVIDE([YTD2021]-[YTD_LastY_2020],[YTD_LastY_2020],BLANK())

here problem is let say YTD_LastY_2020 has -100 dollar sales
YTD2021 has 200 dollar sales then this formula is giving me minus percenatge but in real I have growth of 200 %

so hwo to handle this

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi, bilalkhokar73 ;

    You could try to create a column as follows:

    0Vs1021% = 
var _grow=DIVIDE([YTD2021]-[YTD_LastY_2020],[YTD_LastY_2020],BLANK())
return IF([YTD2021]>[YTD_LastY_2020],ABS(_grow),-ABS(_grow))

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    bilalkhokar73 

    You can do it this way. as per your example, the growth should be 300%

    20Vs1021% = ABS (DIVIDE([YTD2021]-[YTD_LastY_2020],[YTD_LastY_2020],BLANK()) )



  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    5 years ago

    Hi, bilalkhokar73 ;

    You could try to create a column as follows:

    0Vs1021% = 
var _grow=DIVIDE([YTD2021]-[YTD_LastY_2020],[YTD_LastY_2020],BLANK())
return IF([YTD2021]>[YTD_LastY_2020],ABS(_grow),-ABS(_grow))

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.