Forum Discussion

MojoGene's avatar
MojoGene
Post Patron
7 years ago
Solved

Zero divided by zero error - need help

Not sure why this is returning such a strange result:

Expenses YOY % = IF([Expenses Prior Year]=0,BLANK(),DIVIDE([Expenses]-[Expenses Prior Year],[Expenses Prior Year]))

The curent year expenses in this category are $20,655.12. The prior year's expenses in this category were zero. I am trying to get the percentage increase in expenses. 

  

The result I get is 394965993271454000%.

 

Thanks.

  • Found the problem. The measure [Expenses Prior Year] actually came to 0.000000000005230, which is a different problem.

     

    Looks like my measure to calculate the percentage increase was working exactly the way intended.

     

    Sorry for the confusion!

1 Reply

  • Found the problem. The measure [Expenses Prior Year] actually came to 0.000000000005230, which is a different problem.

     

    Looks like my measure to calculate the percentage increase was working exactly the way intended.

     

    Sorry for the confusion!