Complex excel formula to replicate as a custom expression

[Kom Son]

I have an excel formula thats something like =IF(A3=50," ",IF(B3="N/A", " ", IF(OR($A$2=20,$D$2=15),B3,IF(A3=$A$2,B3," "))))

The goal is to populate values in a new column (E) from values in another column (B) based on a couple of conditions. Values in column (B) are determined by the selection in $D$2 which determines the selected parameter type hence the values in column (B) which are parameter values.

In spotfire, I have the dataset with the columns available and have created document properties for the absolute references but creating a custom expression keeps giving me errors using case-when statements. See below:

case

 

when [A] = "50" then " "

else

when = "NA" then " "

else

when [${A selector}] = "20" or [${B selector}] = "15" then

else

when [A] = [${A selector}] then

else " "

end

Help resolving this would be much appreciated!!!

[Gaia Paolini]

Try removing the 'else' in between, you only need the one at the end

case

when [A] = "50" then " "

when = "NA" then " "

when [${A selector}] = "20" or [${B selector}] = "15" then

when [A] = [${A selector}] then

else " " end

also try changing the clause for checking 'NA' (unless is actually a string with value 'NA') to:

when is Null then " "

[Kom Son]

Thanks will try this!!