error Invalid column
GNCM asked 10 years ago
After entering a Calculated field in a smartlist that works is fine when running as a smartlist but it throws the error Invalid column ‘RETURN’ when trying to run it using SmartView. Does anyone know how to address these types of errors?
The SmartList calculated formula is:
CASE WHEN {*UVW_SALES_METRICTONS:Type} = "RETURN" AND {*UVW_SALES_METRICTONS:Metric Tons} <> 0.00000 THEN {*UVW_SALES_METRICTONS:Metric Tons} * -1 ELSE {*UVW_SALES_METRICTONS:Metric Tons} END
The SmartList calculated formula is:
CASE WHEN {*UVW_SALES_METRICTONS:Type} = "RETURN" AND {*UVW_SALES_METRICTONS:Metric Tons} <> 0.00000 THEN {*UVW_SALES_METRICTONS:Metric Tons} * -1 ELSE {*UVW_SALES_METRICTONS:Metric Tons} END
You will need to use single quotes around the RETURN. For example. {*UVW_SALES_METRICTONS:Type} = 'RETURN'. Standard SQL Syntax uses single quotes for data strings. Lorren