Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=Max(If($(vPlace)='1',rating))
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 )
=Max(If($(vPlace)='1',rating))
Thanks Anbu. Seems I didn't need to use aggr after all.