Transform match into set analysis

[timmy]

Hey

Can somebody help me to transform this function into a set analysis?

Match

tnx

Timmy

(Dos_StatusId,1002,1050)<>0

[Miguel_Angel_Baeyens]

Sorry for the double post.

[Miguel_Angel_Baeyens]

Hello Timmy,

If I get you right, you want to check one field to one or more values in set analysis, in this case, finding a match in those values. Then try

Sum({< Dos_StatusID = {1002,1050} >} Sales)

Separating values by comma in the possible list of values will work.

Regards.

[#4]

Yes,

But the problem is that i have an if() around this all.

so the function is if(match(Statusid,1001,1051)<>0),...,....)

the problem is that is use <>0 so i can't use in my set -= or = to compare

...

[Anonymous]

match returns 0 if statusid is not equal to 1001 or 1051

with the if you check if this result is matched or not ...

Think the suggestion of Miguel is correct ... since the Set Analysis says the value should be matching the values {1001, 1050 } .

Miguel A. Baeyens wrote:<pre>Sum({< Dos_StatusID = {1002,1050} >} Sales)

Anita