Skip to Content
0
Former Member
Jan 09, 2009 at 06:22 PM

How to have total result of CKF use the formula of the CKF

356 Views

Hello experts, in a couple of BI reports we need that a Calculated Key Figure's total result use its same formula, instead of using the different calculations that are offered for totals. Let me explain:

We have the following report (please ignore the "-"):

Month---- Entries -- -Exits ----Percentage

Jan--


8
2
--


25%

Feb--


6
3
--


50%

Mar--


8
1
--


12.5%

Result--


22
6
--


Percentage is calculated as "Exits / Entries * 100", or "Exits %A Entries" (in the latter case, the default calculation of total is "average", while in the former it is "sum") and has an exception aggregation of "Average" with reference characteristic "Calendar Month". The problem we have run up with is that we want the result of Percentage calculated the same way, which is somewhat similar to an average. However, the result is always calculated based on the individual results. This gives us different numbers.

Result Percentage = Total Exits %A Total Entries = (6 / 22) * 100 = 27.27% (CORRECT)

Result Percentage = Average of individual Percentages = (25 + 50 + 12.5) / 3 = 29.16% (INCORRECT)

I've tried different approaches, such as changing the reference characteristic and exception aggregation, selecting "average" as the method of calculating results or individual values, checking the "cummulated" and "Also apply to results" checkboxes, etc. but I was unsuccessful.

Any thoughts?