If Statement in Set expression within table

[YanMin]

Hi,

I have a problem with if statement in table column. So I have two condition(1) the calculation including specific brand (2)without those brands. Those two conditions are perfectly work seperately without if statement.

With following codes, it gives me 0 for all columns value. Did I use if statement incorrectly? MTSelection is just to identify the different selection and it is in separate table. 

Appreciate for help. Thank you.

[jwjackso · Accepted solution]

Change If(MTSelection = 'Exclude' to If(GetFieldSelections (MTSelection) = 'Exclude'

[YanMin]

Hi,

Thank you for the answer. I have found the problem. The problem is in other area. But thanks a lot for the answer. Really appreciate it. Can I know the difference between simple if and if getfieldselection?

[jwjackso]

I use the GetFieldSelections() function to force a string to string comparison.