• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

"Percentage Difference" formula needed

I have two currency fields, Current YTD and Previous YTD.

I need a formula that shows the percentage increase or decrease.  I've tried a few things but I'm getting Division by 0 errors.  Either value can be "0".

I need something to display 50, 100, or -50, -100, etc, etc

I'm braindead - can any of you help?

Thanks in advance!


Steve
0
SStroz
Asked:
SStroz
1 Solution
 
carloselfaiteCommented:
I think you could be a litle more clear explaining some of your actual code in order to get the right answer.
0
 
chaauCommented:
you need to use "if then else" syntax to check if the divisor is zero, like this:
If {Current YTD} ={Previous YTD} then 0 else ({Current YTD} - {Previous YTD}) / {Current YTD} * 100

Open in new window

0
 
mlmccCommented:
Actually the formula needs to test the divisor.  Also you are probably looking for the percentage increase/decrease over the previous year

Try this

If {PreviousYear} = 0 then 0 else ({CurrentYear} - {PreviousYear}) / {PreviousYear} * 100

mlmcc
0
 
SStrozAuthor Commented:
Thanks Michael!!!


Steve
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now