formula in result rows

[Former Member]

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

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

It did not work.