Skip to content
+1-888-319-3663

COMMUNITY FORUM

error Invalid column

GNCM asked 9 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
Lorren replied 9 years ago

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

Answers
Best Answer
GNCM answered 9 years ago
Thank You Lorren you answer worked; it is always those small things that get you.   

If you would like to submit an answer or comment, please sign in to the eOne portal.