Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi,
Try Like this,
=if(prodpoolid=20 and wildMatch(itemid,'5c*'),valve)
Regards,
hi,
Try Like this,
=if(prodpoolid=20 and wildMatch(itemid,'5c*'),valve)
Regards,
thanx