Yellowfin not picking up field names in calculation
I am attempting to create a custom calculated field in a report using the "Freehand SQL" option, but Yellowfin is not recognising the name of one of the columns involved. I've tried a number of variations on the column name/indicators that it is a column name (e.g. "Days In Port", 'Days In Port',[Days In Port], Days_In_Port etc.)
The "Days In Port" column is calculated in the view underlying the report. The "Maximum Possible Days" column is calculated in the report and is of Date type.
I have attached an image of the calculation I am attempting and the error message I receive. Any thoughts/solutions appreciated.