topic Re: How do I correctly add an AND operator to my expression? in App Development

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

Compacte — Wed, 19 Apr 2023 14:10:17 GMT

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.

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

BrunPierre — Wed, 19 Apr 2023 17:58:29 GMT

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

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

Compacte — Wed, 19 Apr 2023 14:42:21 GMT

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

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

mk1dangi21 — Wed, 19 Apr 2023 16:54:52 GMT

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.

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

BrunPierre — Wed, 19 Apr 2023 17:59:13 GMT

How about just like this.

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

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

Kushal_Chawda — Wed, 19 Apr 2023 20:44:01 GMT

@Compacte can you share sample with expected output?

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

Compacte — Sat, 22 Apr 2023 13:53:04 GMT

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