Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
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?
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!