Minus signs

Question

Hello,

There is probably an easy way but I haven't found it yet.

I have a  table looking like this

Tax base amount Tax2.000,00- 420,00-24.825,10- 5.213,27-24.820,105.209,27

And I would need to get this as fixed decimals...

Any quick idea?

Christina_H · Answer

Can use this in a multifield formula:

ToNumber(REGEX_Replace([_CurrentField_],"(.*)(-)","$2$1"),0,0,",")

Nicolaas_Vercruyse · Answer

yes

caltang · Answer

The thousand separator is a "."?