Three valuas in set analysis

[#1]

Hi ,

I would appreciate help with the following. I have a set analysis expression where i use a period and then where a tarricode must filter on 3 values for tarricode. I have tried the following but it is not working

Sum({$<Period={$(=Max(Period)-1)},TariffCode={'58081'},TariffCode={'58071'},TariffCode={'H081'}>}(AmountExcl ))

In normal sql statement it would be where tarrifcode in ('value1','value2','value3') - how does one put this into a set analysis ?

Thank so much.

Louw

[Miguel_Angel_Baeyens · Accepted solution]

Hello Louw,

You are almost there:

Sum({< Period = {$(=Max(Period)-1)}, TariffCode={'58081', '58071', 'H081'} >} AmountExcl)

Hope that helps.

[#3]

and this worked for me. Thanks so much.

Regards

Louw