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
    6 years ago

    rdiazd73 ,

    Try like

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

  • amitchandak's avatar
    amitchandak
    6 years ago

    rdiazd73 

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

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