Creating dimension with "IF" "AND" conditions

[avishaiz]

hi

i want to create a dimension using "If" "And"

the dimension needs to answer two criteria

prodpoolid=20

itemid starts with 5c

if both conditions are true than i want to make a dimension called "valve"

thanks.

[pathiqvd · Accepted solution]

hi,

Try Like this,

=if(prodpoolid=20 and wildMatch(itemid,'5c*'),valve)

Regards,

[avishaiz]

thanx