This content has been marked as final.
Show 5 replies

1. Re: Percentage calculation
. Indumon Sep 24, 2013 10:15 AM (in response to Antonio Willybiro)Antonio, Use table calculations Window_Sum or Window_Avg, I hope that will work!

2. Re: Percentage calculation
Ben Neville Sep 24, 2013 12:44 PM (in response to Antonio Willybiro)It's hard to conceptualize this... can we get a screenshot?
Off the top of my head, I would say that something like:
SUM([Leavers]) / AVG([Headcount])would work. If this is not the case, it's likely you need to leverage table calculations... some combination of WINDOW_SUM, WINDOW_AVG, SUM, and AVG should do the trick.


4. Re: Percentage calculation
Antonio Willybiro Sep 26, 2013 3:48 AM (in response to Antonio Willybiro)hi there  any other suggestions?
Thanks
Antonio

5. Re: Percentage calculation
Antonio Willybiro Sep 26, 2013 5:49 AM (in response to Antonio Willybiro)i managed to solved it
 created a Set with just the value I needed from the dimension [account_name]
 put that set on a table
 applied the following table calculation: (ZN(SUM([Actual + QRF])) / LOOKUP(ZN(SUM([Actual + QRF])), LAST()))*1
The 1 is because I have my leavers numbers as negative and I wanted to reverse that for the bar chart display.