This content has been marked as final.
Show 2 replies

Re: lookup value from a different table that has no joins
Sunny Talwar May 31, 2017 2:13 PM (in response to John Matias)May be this(assuming Category is your dimension)
=Max(Aggr(If(Sum(PositiveAnswer)/Count(AnswerId) >= Score, Percentile), Category, Score))
or this (assuming Year is your dimension)
=Max(Aggr(If(Sum(PositiveAnswer)/Count(AnswerId) >= Score, Percentile), Year, Score))
or this (assuming Category and Year as dimensions)
=Max(Aggr(If(Sum(PositiveAnswer)/Count(AnswerId) >= Score, Percentile), Category, Year, Score))

262458.qvf 176.0 K

Re: lookup value from a different table that has no joins
John Matias May 31, 2017 3:36 PM (in response to Sunny Talwar )Thank you very much. That worked great. I tried to use Aggr but couldn't figure out the proper way to use it. Many thanks.
