2 Replies Latest reply: Mar 27, 2011 6:09 AM by louwter1 RSS

    Three valuas in set analysis

    louwter1

      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