8 Replies Latest reply: Dec 9, 2015 5:53 AM by balraj ahlawat

# Numerator as one row  by Denominator the whole column

Hi GuYS

What's the best way to do in a KPI where i want to take each value from one dimension as the Numerator divided by all the vales in that column as the Denominator? Is it best to do in the script or expression and how?

Regards

• ###### Re: Numerator as one row  by Denominator the whole column

Could you explore more with some sample data??

• ###### Re: Numerator as one row  by Denominator the whole column

Are you trying to do something like this:

Dim1     Val

A          10

B          15

C          25

and in the KPI you are trying to do for A -> 10/50?

For this you can try Sum({<Dim1 = {A}>}Val)/Sum(Val)

If this isn't what you are looking for, please elaborate on what you are looking to do.

Best,

Sunny

• ###### Re: Numerator as one row  by Denominator the whole column

I guess, he is asking for Val=10 as Numerator and sum(Val)=50 as Denominator...

If yes, try with total:

sum(Val)/sum(total Val)

• ###### Re: Numerator as one row  by Denominator the whole column

Thanks for pointing that out Balraj. The expression was suppose to do 10/50, but I mistakenly wrote 10/25

• ###### Re: Numerator as one row  by Denominator the whole column

like this?

• ###### Re: Numerator as one row  by Denominator the whole column

sum(Column)/sum(total Column) ?

• ###### Re: Numerator as one row  by Denominator the whole column

Thanks guys, i just need to test something else before i can test this as it's not as straight forward as i've posted, i'll elaborate later.

• ###### Re: Numerator as one row  by Denominator the whole column

It seems, you were playing with us