on 09-10-2010 12:38 PM
Hi,
I would like to calculate the relative revenue (= revenue / revenue of the biggest market participant) in the BEx Query Designer. I have a key figure "revenue" and my market participant as characteristic.
I first tried to create a formula like "revenue / max(revenue)" but this doesn't work that way in Query Designer. I now tried to solve this with a calculated keyfigure but don't come to a solution.
How can I do a calculation like this in Query Designer?
Thanks!
Create a 'Replacement Path' variable having reference to 'Market Participant' characteristic. Use this variable in your formula and use the Max. function on 'Market Participant' variable.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
create a calculated key figure (CFK) based on your key figure (KF) and take the max for exeption aggregation. then you can create a formula as : KF %A CFK_1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.