Replacing by set analysis?

[timmy]

Can i replace the if by a Set An?

if(match(Dos_StatusId,1000,1001,1002,1003,1004,1006,1008,1009,1050,1051,1052,1126)=0,......)

tnx

[#2 · Accepted solution]

Something like this may work:

Sum({<Dos_StatusId -= {1000,1001,1002,1003,1004,1006,1008,1009,1050,1051,1052,1126}>} Sales)

That would only Sum values where Dos_StatusId is not in that list. Is that what you're looking for?