In Reports > Disable currency in Price field

I have created a Rows and Column report and use the field Price which shows what currency it is. I would the exported report not to show the currency before the amount. Can I set this up somewhere?

e.g. SEK3000 should be only 3000

Parents

0 André Lopes over 3 years ago

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.

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up +3 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Hugo Geyskens over 3 years ago in reply to André Lopes

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Björn Canales Pfisterer over 3 years ago in reply to Hugo Geyskens
Hi Hugo Geyskens

the formula is:

related($currencies,"name")

It pulls the name of the currency record (you've set up in admin area) instead of the symbol :-)

Bests

Björn Canales Pfisterer

Technical Support Manager

provalida GmbH

--

https://www.provalida.de

support ( at ) provalida.de
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Björn Canales Pfisterer over 3 years ago in reply to Hugo Geyskens
Hi Hugo Geyskens

the formula is:

related($currencies,"name")

It pulls the name of the currency record (you've set up in admin area) instead of the symbol :-)

Bests

Björn Canales Pfisterer

Technical Support Manager

provalida GmbH

--

https://www.provalida.de

support ( at ) provalida.de
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data