This content has been marked as final.
Show 4 replies

1. Re: Create a "Percent Of" calculation instead of "Percent Difference"
Ivan Young Sep 30, 2016 4:30 PM (in response to Derek Manning)1 of 1 people found this helpfulHi Derek,
Why don't you try 1+Percent Difference. That should give you what you are looking for.
Regards,
Ivan

2. Re: Create a "Percent Of" calculation instead of "Percent Difference"
Shinichiro Murakami Sep 30, 2016 4:48 PM (in response to Derek Manning)Current one is described as
[% Difference]
(ZN(SUM([Value]))  LOOKUP(ZN(SUM([Value])), FIRST())) / ABS(LOOKUP(ZN(SUM([Value])), FIRST()))
inversed one should be
[% Difference inverse]
if index()<>1 then 1((LOOKUP(ZN(SUM([Value])), FIRST()))ZN(SUM([Value]))) / ABS(LOOKUP(ZN(SUM([Value])), FIRST())) end
You can create table calc thru given function
then drag to the measure field (with ctrl)
and you can get new formula as "calculation ***"
Then modify it as you like.
Thanks,
Shin

table _calc SM_9.2.twbx 10.6 KB


3. Re: Create a "Percent Of" calculation instead of "Percent Difference"
Derek Manning Sep 30, 2016 5:06 PM (in response to Shinichiro Murakami)Thanks so much, especially for the picture walkthrough. This worked perfectly!!

4. Re: Create a "Percent Of" calculation instead of "Percent Difference"
Shinichiro Murakami Sep 30, 2016 5:51 PM (in response to Derek Manning)You are very welcome
Shin