Question:
Hi,
I have this formula in a query based on Customer infocube:
share% = %RT 'Profit Margin'
Profit Margin is also a calculated key figure.
The problem I am facing is : This formula is giving wrong answers.
For Profit margin, I have set 'Calculate result as' - summation.
The overall result is shown as : 1,882.51 *
But share% is 0 * (but with a cell value 0.23354)
Any clue to this problem is highly appreciated.
Thanks in Advance
GS.
Answer:
the issue is that all the functions on the totals (CT/RT/GT) work on the 'real' query total (or better : the 'original'), not on the total that you have forced through 'Calculate reuslt as'...
Really annoying, but that's just how it functions. I'm thinking the reason is the following: the total-functions like %RT are calculated in the OLAP-processor (before the query comes to the front-end). However, the 'calculate result as' is only done in front-end (so after the olap calculations. So, when he applies the %RT, he does not know yet that the result in the report is different (aka overwritten in the front-end).