
1. Re: % Difference Calculation
Chris McClellan Oct 13, 2018 5:24 PM (in response to Adrian Santana)Can you supply some dummy data and maybe a workbook please ?

2. Re: % Difference Calculation
Oussama IMAOUEN Oct 13, 2018 8:50 PM (in response to Adrian Santana)Hi ,
Please change your calculated field of the percent with this one :
ZN((ZN(SUM([2018]))ZN(SUM([2017])))/zn(SUM([2017])))
Zn function return 0 if the value is null, in your case you return 1 when the 2 values are 0, that's why you have 100%
Hope it helps

3. Re: % Difference Calculation
Adrian Santana Oct 14, 2018 9:45 AM (in response to Oussama IMAOUEN)Your formula worked to get me 0 for the percentage when 2018 = 0 and 2017 = 0 so thank you!
Now I have 2 different % difference columns, one comparing based off of 2018 and the other based off of 2017. I need this combined into a calculation to make a single % difference column.
I really wanted it to be where % difference would give a negative or minus based off of 2017.
Examples:
2018: 5000
2017: 1750
% DIFF: 96.29%
2018: 1750
2017: 5000
% DIFF: 96.29%
2018: 5000
2017: 0
% DIFF: 100%
2018: 0
2017: 5000
% DIFF: 100%
2018: 0
2017: 0
% DIFF: 0
Is this possible for 1 column?
I can't figure this out.
Thank you in advance.

4. Re: % Difference Calculation
Oussama IMAOUEN Oct 14, 2018 3:29 PM (in response to Adrian Santana)Please can you explain how did you get %DIFF = 96.29% in the first example:
2018: 5000
2017: 1750
% DIFF: 96.29%

5. Re: % Difference Calculation
Adrian Santana Oct 14, 2018 4:30 PM (in response to Oussama IMAOUEN)Actually, that was an error on my part.
I did percent difference. I need to do the percent change. I've been mixing them up.
V2  V1 / V1 x 100

6. Re: % Difference Calculation
Oussama IMAOUEN Oct 14, 2018 5:24 PM (in response to Adrian Santana)Not sure if I am following your comment correctly, but I thin the formula I gave you will work in your case.
It could be helpful if you share your workbook