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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
Right, because it is dividing by zero,but it looks like you are using the third parameter of the DIVIDE function to account for this kind of error, right? Maybe just try 0 in that third parameter?