topic Re: Round() does not work with US-format seperators in App Development

Round() does not work with US-format seperators

fneumann — Thu, 22 Dec 2022 10:46:44 GMT

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!

Re: Round() does not work with US-format seperators

hic — Thu, 22 Dec 2022 15:16:10 GMT

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?

Re: Round() does not work with US-format seperators

fneumann — Thu, 22 Dec 2022 16:14:11 GMT

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!