Q1 = -5
Q2 = 0
Doing standard percent calculation (even using an ABS) we keep getting percent change = 100%
Would it not be 500%? What are we doing wrong? What is correct formula?
Q1 = -5
Q2 = 0
Doing standard percent calculation (even using an ABS) we keep getting percent change = 100%
Would it not be 500%? What are we doing wrong? What is correct formula?
Last edited by dbb; 07-24-2007 at 11:34 AM. Reason: help title search stand out
Hi,
Your change is 5, on a value of 5 , that is 100%. What's the problem?
Ed
We had a result of -5 in Quarter one and got better to actually raise the result to a 0 in Quarter two. I guess I am seeing that as a much bigger number than 100%
'=if(ac51=0, -1*(am51),
If(am51<>ac51,(ac51-am51)/(ac51*sign(ac51)),
(am51-ac51)/(ac51)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks