Instead of IF condition

[geogou1973]

Hello,

I have the following expression in Add Calculated Dimension

=if(CAPRAR='ST' or CAPRAR='SZ',STICKER,ITEM_ID)

how can i replace this command with another that not contains if command ?

I have problem with performance when i use the command if

Thank you in advance.

[aarkay29]

pick(WildMatch([CAPRAR],'ST','SZ','*'),STICKER,STICKER,[ITEM_ID])

This might work just give a try