Aggregate using a Variable

[Anonymous]

Hi

I have defined a variable $(vPlace) that can either be 0 or 1.  I want to try and find the max value of "rating" if $(vPlace) equals 1 but with my current attempt the result returned is null

My expression is: =aggr(max(rating),($(vPlace)='1'))

I'm struggling to find the correct syntax to make this work - any help appreciated.

Thanks

Matt

[JonnyPoole]

if( $(vPlace) = 1 , max(rating)  )  -> will calculate the max rating if your variable is 1. 

Is place a field in your data model and you want to calculate the maximum rating when place = 1  ? 

something like this

max (  {$<Place = {'$(vPlace)'}>}  Rating )

[anbu1984 · Accepted solution]

=Max(If($(vPlace)='1',rating))

[Anonymous]

Thanks Anbu.  Seems I didn't need to use aggr after all.