Round() does not work with US-format seperators

[fneumann]

Hi all!

I'm facing a problem with round()-function.

Located in Germany, I usually use for numbers:

SET ThousandSep='.';
SET DecimalSep=',';

Now I need to do some stuff for our US company and there I'm changing the format to 

SET ThousandSep=',';
SET DecimalSep='.';

Everything looked fine so far, but when I use round(value,0.01) like before, it will not work correctly because of the format. The only solution, I have now, is to make a new SET-statement before and after the round()-function.

Does someone have an idea, how this can be solved in a better way?

Thanks a lot in advance!

[hic · Accepted solution]

It should work. In expressions, the engine ALWAYS uses decimal points.

Could you show more details about it so we can see whether it's a bug or not?

[fneumann]

For some reason, the problem does not come up again.  I cannot tell what is different from my last try.

I will monitor this for a while and when I see it again, I will show it here. 

Thanks so far!