
Re: Numerator as one row by Denominator the whole column
balraj ahlawat Dec 9, 2015 5:34 AM (in response to lakwinder singh)Could you explore more with some sample data??

Re: Numerator as one row by Denominator the whole column
Sunny Talwar Dec 9, 2015 5:46 AM (in response to lakwinder singh)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
balraj ahlawat Dec 9, 2015 5:43 AM (in response to Sunny Talwar )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
Sunny Talwar Dec 9, 2015 5:46 AM (in response to balraj ahlawat)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
balraj ahlawat Dec 9, 2015 5:40 AM (in response to lakwinder singh)like this?

Tes.qvw 155.5 K


Re: Numerator as one row by Denominator the whole column
Martin Mahler Dec 9, 2015 5:44 AM (in response to lakwinder singh)sum(Column)/sum(total Column) ?

Re: Numerator as one row by Denominator the whole column
lakwinder singh Dec 9, 2015 5:51 AM (in response to lakwinder singh)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
balraj ahlawat Dec 9, 2015 5:53 AM (in response to lakwinder singh)It seems, you were playing with us
