cancel
Showing results for 
Search instead for 
Did you mean: 

formula in result rows

Former Member
0 Kudos
52

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello,

You might want to create the Formula KF by putting the Function

KF = SUMCT (Count / Quantity)

OR

KF = %CT (Count / Quantity)

This should work fine.

Regards

Former Member
0 Kudos

It did not work.

Answers (0)