Need help in set analysis

[#1]

Hi,

as I have two fields are first one is Year and next one is status.

Year contains 2012 and 2013 and the status contains A,B,C,1

as I need a  expression that 2012 and excluded of A, so I tried a expression as in the below, but its not working, could you please anyone correct me.

=Sum({1<Year={$(PY)} - Status="{$('A')}"}>}Sales))

Regards

Chriss

[tresesco · Accepted solution]

Exclude 2012 and A ?

Try this:

Sum({<Year={*}-{2012}, Status={*}-{'A'}>} Sales)   // assuming that you want this irrespective of selection.

Sum({<Year - ={2012}, Status - ={'A'}>} Sales)  // if you want to consider the selection

[MayilVahanan]

HI

Try like this

= Sum({<Year = {$(PY)} , Status -= {'A'}>} Sales)

Hope it helps

[#4]

Hi,

thanks for your reply.. as I need to select the Year and not equal of Status 'A' but I done it through your example...

Thanks a lot