There are three layers to the answer that you will have to understand.
Firstly, you cannot do mathematical functions between a string and a decimal/ integer. So You will have to convert the string to a decimal format ( eg: parseDecimal('Your String value', '#,###.##').
Secondly, this will allow you to do a mathematical function as shown below: parseDecimal('Your String value', '#,###.##') * 1000.
Thirdly, you can convert them into a string format using toString(parseDecimal('Your String value', '#,###.##') * 1000) or formatdecimal()
Hi,
You need to use ParseDecimal to convert the String to a Decimal. You can then multiply this value by 1000, and use formatDecimal to convert that back to a String.
https://docs.mendix.com/refguide/parse-and-format-decimal-function-calls
Something like this should work, but you may need to tweak it to match your exact requirements.
formatDecimal(parseDecimal($IteratorAll_Import_FPW/ActualCostDown) * 1000), ‘#,###.#’ )
Hope this helps
Hello Ikhwan,
You cannot do mathematical operation with string. Convert the string to integer (parse it) and then do this operation.