Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a dimension called VendorContactConflictFlag that only has the value 1 or is null.
When using the expression below for records that do not have a value of 1 (i.e. null values), it gives the correct outcome of 0.
IF(VendorContactConflictFlag=1,1,0)
When using the second expression for the same records, it does not evaluate correctly and gives a value of 'Yes'.
IF(VendorContactConflictFlag=1,'Yes','No')
Would appreciate any help on why this is happening!
Cheers,
Joel
did u chk with the variable name alrdy declared? twice?
Cntrl+Alt+V
Can you put them side by side in your application and check what you get?
IF(VendorContactConflictFlag=1,1,0) & ' ' & IF(VendorContactConflictFlag=1,'Yes','No')
Do you still get 0 Yes?
Hi Sunny,
I get the correct answer when I paste your formula in (0, No).
Not sure why this is the case - could you please enlighten me?
I have no idea, may be you had some not right? (Spelling mistake, Upper case/lower case issue)
If you now paste this -> IF(VendorContactConflictFlag=1,'Yes','No') it should give you no right?