K3 Documents

Convert EU Currency Value Stored in String to Decimal

Updated Jul 28, 2021

This formula takes a EU currency value which was originally stored in a string format as "99999,99" and converts it to a decimal 99999.99 .

Float.parseFloat({Spend (REF)}.replace(',', '.'))
Previous Article 'Like' Regex Values for Use with When Statements
Next Article How Do I Use Reporting?