Details about this thread
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 2 replies
  • Subscribers 294 subscribers
  • Views 1342 views
  • Users 0 members are here
Related content from around SugarClub

Decimal field not saving (precision 2, max size 18)

Karen Valle

I have a decimal field with precision 2 and a max size of 18. Through some math, I got the number 2.45628549725315e^(-4) [calculation done by hand to check the math]

Shouldn't this number have been truncated at 2 decimal places, avoiding the max size issue altogether? The field is a financial multiplier which is why I used a decimal. Am I correct in my assumptions?

We're on Enterprise 7.5.0.1

Thanks!

Parents
  • 0

    Hi Karen Valle,

    If i understood your problem correctly,You are trying to save "2.45628549725315" this value to one decimal field which is having precision-2 max size-18.It will not allow us to save.The reason is your precision(.45628549725315) length is 14.but you have given precision to 2.So it is truncating remaining numbers.So you should increase precision number for your field.

    Thanks!.

Reply
  • 0

    Hi Karen Valle,

    If i understood your problem correctly,You are trying to save "2.45628549725315" this value to one decimal field which is having precision-2 max size-18.It will not allow us to save.The reason is your precision(.45628549725315) length is 14.but you have given precision to 2.So it is truncating remaining numbers.So you should increase precision number for your field.

    Thanks!.

Children