Removing a char from the end of my string and add them at the beginning

[emrekaya]

Hi all, in my report, negative values comes in a weird way and because of that I can't sum them up. If you help me, I would be glad.

As it is shown in the picture below, negative numbers come as "#.##-'.  I know how to remove (-) sign from the string but I have no idea how to make that string negative again. Thanks.

[shiveshsingh]

Hi

After removing the (-) sign, why don't you put (Dim * -1) while loading!

[emrekaya]

It is not possible, because there are positive data in the column also. That would make them negative.

[marcus_sommer · Accepted solution]

Just converting/formatting the data would be enough, for example with something like this:

num(num#('1.005,14-', '#.###,00;#.###,00-',',','.'), '#.##0,00')

- Marcus