4 Replies Latest reply: Feb 16, 2010 6:22 AM by Anita Fuchten

# Transform match into set analysis

Hey

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

Match

tnx

Timmy

(Dos_StatusId,1002,1050)<>0

• ###### Transform match into set analysis

Sorry for the double post.

• ###### Transform match into set analysis

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.

• ###### Transform match into set analysis

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

...

• ###### Transform match into set analysis

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