Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My expression
Avg({$<GeoAreaName = P({<GeoAreaName = {'Belgium'}>})>}{$<SeriesCode = P({<SeriesCode = {'AG_LND_FRST'}>})>}Value)
Is only giving me the result of the second "filter" and I don't know how to add a AND operator to this.
you can try the following approach:
Avg({$<GeoAreaName = P({<GeoAreaName = {'Belgium'}>}), SeriesCode = P({<SeriesCode = {'AG_LND_FRST'}>})>}Value)
This expression combines both conditions inside a single set analysis expression. The expression calculates the average 'Value' when both 'GeoAreaName' is 'Belgium' and 'SeriesCode' is 'AG_LND_FRST'. By placing both conditions within the same set analysis, the AND operator is implicitly applied.
Avg({$<GeoAreaName = {'Belgium'}, SeriesCode = {'AG_LND_FRST'} >} Value)
Thanks for the reply, unfortunately it still only gives the result of the first half.
you can try the following approach:
Avg({$<GeoAreaName = P({<GeoAreaName = {'Belgium'}>}), SeriesCode = P({<SeriesCode = {'AG_LND_FRST'}>})>}Value)
This expression combines both conditions inside a single set analysis expression. The expression calculates the average 'Value' when both 'GeoAreaName' is 'Belgium' and 'SeriesCode' is 'AG_LND_FRST'. By placing both conditions within the same set analysis, the AND operator is implicitly applied.
How about just like this.
Avg({$<GeoAreaName = {'Belgium'}, SeriesCode = {'AG_LND_FRST'} >} Value)
@Compacte can you share sample with expected output?
This worked indeed. I'm guessing it was the single set analysis which was needed. Thank you!