Validation for number range with numbers 300000000000 to 999999999999

[Former Member]

Hello all,

I created a validation for a number range, where the numers are very large. I created some fields to hold the upper and lower limits. I created them as Real, so they would be large enough to hold the numbers in question. When I try entering the data in the fields, it shouls up as 3e011 (instead of 300000000000) and 9.999999e011 (instead of 999999999999).

When I validate the data, the actual values in the range are 299999985664 to 999999930368. Any suggestions how to get it to be the actual values?

I have another number range from 10000000 to 99999999999. The 10000000 works great, but the 99999999999 only really validates up to 99999997952.

Please let me know if you have any suggestions.

Thanks,

Chuck

[Former Member · Accepted solution]

Hi Chuck,

Due to its nature, a variable of type "Real" cannot store the exact number if it is too large (related to the size of the variable) - you see the result!

There seems to be no integer data type for larger numbers in MDM (such as LongInt).

If it is possible to live with less flexibility, you could use fixed multiplier, in the validation, together with a smaller variable value.

E.g.:

Lower limit = variable1 * 10000000

Upper limit = variable2 * 99999999999

Then you'd have

variable1 = 30000

variable2 = 1

for the first validation, and

variable1 = 1

variable2 = 1

for the second. All these values would be well in range of the Integer data type.

For more flexibility, a more complex formula could be used...

Maybe it is also possible to use fields of type "Text" - but I haven't tried.

Best regards,

Dennis

[Former Member]

Silpa,

That was how I had originally created the fields. But, thank you for the reply.

Dennis,

Great idea! That worked. Thank you!!

Thanks,

Chuck

[Former Member]

Hi Chuck,

While creating the fields with type real select the field properties - "Decimal Places" - 0 and "Show Fractions" - No in the console.

I think this will solve your problem.

Best Regards,

Silpa Chillakuru