In Reports > Disable currency in Price field

Let me evolve a bit the suggestion from Dmytro Chupylka. Create a float field instead. As a string field certainly the report will mess up such a column on ordering by its, once it will order as a string instead of a number.

Hi there,

To make this solution complete (we know now how to extract the numeric value, thanks for that), what would be the best way to extract the currency indicator ? (SEK, AUD, $, ...) and why is the US Dollar not represented by USD instead of $ ?

So as to split the original SEK51,45 into SEK and 51,45...

Bye  now

Hugo

the iso4217 indicator could be retrieved with formula

related($currencies,"iso4217")

good point. On my instance the records having the indicator as the name but this is more precise :-)

Bests

Björn Canales Pfisterer

Technical Support Manager

provalida GmbH

--

https://www.provalida.de

support ( at ) provalida.de

good point. On my instance the records having the indicator as the name but this is more precise :-)

Bests

Björn Canales Pfisterer

Technical Support Manager

provalida GmbH

--

https://www.provalida.de

support ( at ) provalida.de