Need help with expression filter

[Anonymous]

Hi,

     I found out that there's another way to do aggregation based on a filter, I got this....

sum({<Period={"H211"}>} HC) this works just fine (and for a unknown reason, if statement is not working, maybe because it's nested with other formulas)

The thing is, is there anyway to make it flexible like

sum({<Period like "H2*">} HC)

[#2 · Accepted solution]

Hi Oscar,

Have you tried sum({<Period={"H2*"}>} HC) ?

This should work if all you need is a wildcard search.

Kind regards

Andrei Popescu

[Anonymous]

Hi Andrei, that was it! I never tried that... shame on me, well thank you very much!