Converting column values like "14.5M" to "14500000"
A feature has values consisting of the amount plus a monetary unit (either "M" or 'K'). The desired conversion is to extract the amount and multiple it according to the monetary unit to get a "normalised" representation for the monetary values. I have no problem extracting the amount and unit (as two new columns) using split with regex and the capture mode. What I couldn't get it work is to use a computed function to produce the "normalised" amount into a new column. The system complained that a computed function like "IF(@Value Unit@='K', @Value Amt@ * 1000, @@Value_Amt@)" is syntactically incorrect