Querying Database With Large Decimal

Im having an issue where if I have a large decimal that I am using in my queryFilter to query the database with, the query crashes.

a!queryFilter(
field: "minDevCost",
operator: "<=",
value: ri!devCost
),
a!queryFilter(
field: "maxDevCost",
operator: ">=",
value: ri!devCost
)

The CDT field is a numeric (Decimal).

If I enter in a decimal of 9000000000, the query crashes.
if I enter in a decimal of 9000000000.00, then the query processes fine.

However, I cannot force the number to have 2 decimal places as if I use the text function
text(9000000000, "###############.##")
I get back N/A

I tried the fixed function as well and this did not work.

Any other suggestions to get this to work?

OriginalPostID-257369

  Discussion posts and replies are publicly visible

Parents
  • todecimal doesnt work either. The input is already a numeric(decimal) anyway.

    Just to be clear, the issue is not with my code, it appears to be an issue with the expression editor. When a large number is entered into the expression field, the value is infinity which causes the rule to fail when trying to test the rule. Entering the same value into the value field works fine.

Reply
  • todecimal doesnt work either. The input is already a numeric(decimal) anyway.

    Just to be clear, the issue is not with my code, it appears to be an issue with the expression editor. When a large number is entered into the expression field, the value is infinity which causes the rule to fail when trying to test the rule. Entering the same value into the value field works fine.

Children
No Data