Set analysis sum

josemaria_cabre — Sat, 16 Nov 2024 21:03:42 GMT

Hi Everyone,

I have following Table:

My objective is to sum only items greater than Last Year.

In this example, this would be items c,d,e and g and expected result is 42 (8+10+15+9).

I tried to accomplish this, using expression:

=Sum({<ThisYear={'=ThisYear>LastYear'}>} ThisYear)

As you can see, item d is greater ThisYear than LastYear, but it doesn't appear in table. What am I doing wrong?

Thanks in advance for your help.

Jose.

Re: Set analysis sum

Gysbert_Wassenaar — Fri, 12 Apr 2019 09:46:32 GMT

Try: =Sum({<[item]={'=sum(ThisYear)>sum(LastYear)'}>} ThisYear)