Kom Son Posted July 22, 2021 Posted July 22, 2021 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 Posted July 23, 2021 Posted July 23, 2021 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 " "
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now