on 10-17-2008 10:33 AM
i have a formula KF in key figure columns.
It is a ratio of count/quantity. say: KF = count/quantity
I want result rows of formula key figure (KF) to be based count in result rows and quantity in result rows.
By default result of KF is based on sum of all KFs in rows of KF column.
I want it to be only based on
ratio of result of count to result of quanity.
Please help.
Thanks
Hi Rajiv,
I think by default it gives ratio of the sums only , in the result row.
In BI7 if u want it as total of the values in the column u give in 'calculations' tab as 'calculate result as' as 'total'.
if 3.5 u can define that in 'properties' of the key figure by right clicking
hope it helps.
Regards,
Rathy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.