APEX 5.1.2
If I have a NUMBER columns (e.g. SAL and COMM) in an IG row with a currency number format mask (e.g. FML999G999G999G999G990) and a derived column (Add Column - Source Type = None) to add them up with a Set Value Dynamic action, it chokes on the formatting (currency symbol and commas) in the numbers! e.g. Ajax call returned server error ORA-06502: PL/SQL: numeric or value error: character to number conversion error for Set Value.
My [Set Value] DA is a [PL/SQL Expression] like NVL(:SAL,0) + NVL(:COMM,0).
Surely I am missing something and there is a better way to handle this sort of thing?! The reason I am a little incredulous is that I thought the DA would use the "raw" value of the column and not the value displayed in the cell which may have format masks and even HTML Expression applied. @"John Snyders-Oracle" - Any suggestions? Or should I just undo the format mask in the PL/SQL expression using to_number(:SAL,'FML999G999G999G999G990)
Thanks