How do I correctly add an AND operator to my expression?

[Compacte]

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.

[BrunPierre]

Avg({$<GeoAreaName = {'Belgium'}, SeriesCode = {'AG_LND_FRST'} >} Value)

[Compacte]

Thanks for the reply, unfortunately it still only gives the result of the first half.

[mk1dangi21 · Accepted solution]

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.

[BrunPierre]

How about just like this.

---

Avg({$<GeoAreaName = {'Belgium'}, SeriesCode = {'AG_LND_FRST'} >} Value)

[Kushal_Chawda]

@Compacte  can you share sample with expected output?

[Compacte]

This worked indeed. I'm guessing it was the single set analysis which was needed. Thank you!