Forum Discussion

rdiazd73's avatar
rdiazd73
Icon for Helper I rankHelper I
6 years ago
Solved

PREVIOUSMONTH & DIVIDE ERROR

Hello guys thanks in advance for your help I need the percentage of growth or decrease from one month to another, the problem appears when the stock of the previous month is 0, it does not calculat...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

rdiazd73 ,

Try like

DIVIDE(([_STOCK 9L]-[_PREV M 9l]);[_PREV M 9l])

rdiazd73's avatar
rdiazd73
Icon for Helper I rankHelper I
6 years ago

 

Hi
thanks for your help
your formula partially fixes the error, ok the erroneous percentage disappears,

but it should propose a growth percentage stock previous month 0 current stock 2 percentage increase + 200%, no ?

thanks

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    rdiazd73 

    Previous Month is 0, so % increase is infinity 2/0