Verify transform numeric values

[joker]

Hi,

if I verify a numeric value (real), I think this should follow the number format set for the program…

I’d say, that wrong formated numbers between english and german display is the most common problem I have to deal with…

so in the set

12,0021
12.0021

one should not pass the verify numeric (real), but presently, both do pass…

What do you think?

Best,
Jochen

[Olaf]

I would use in the verification the check if there is a “,” or a “.” included:

[Admin]

This is what I get:

That is what you would expect, isn’t it?

[Olaf]

did overlook the “Numeric overlook listed” selection, therefore my suggestion in the contains field.

[Olaf]

I found in the documentation for NaN:

NaN means ‘not a number’. It can be returned by some calculations, for example using Calculate to raise 1000 to the power 1000 will overflow numerically and return NaN.

Are there any other possible selections in that field or is a dedicated entry only senseful in case of date as the date field is on the same position?

[Admin]

You can put a comma separated list of any values that you will except that aren’t real numbers.