Hi All, I am trying to set scale = 8 in a decimal table entry, but the scale attribute cannot be found in Attribute field(when I type in key word 'scale', it shows Number of rows removed from this list by Security constraints: 1 ). My version is Gene

[weng]

Hi All, I am trying to set scale = 8 in a decimal table entry, but the scale attribute cannot be found in Attribute field(when I type in key word 'scale', it shows Number of rows removed from this list by Security constraints: 1 ). My version is Geneva. Thanks for your kind attention!

[anavarro]

I'm having the same issue as Weng but when I updated my Max length field, it didn't sort it for me.

I've tried adding ",scale=5" to the Attributes field since I could not find it on the Attributes related list. I still get a 1.54 value on the field itself even though the variable I have used and logged to set the field says 1.53800.

If you're still struggling with this, please hit the upvote button so this question has more visibility.

[yadavkiran]

Hello So There is a basic Logic behind this 

If the Scale = 5

And the Type of Field is 'Decimal' the dafult max length of the decimal is 15

So in order to make this scale works we need to give 15 + 5(Scale ) - 25 Max Length and Scale = 5 in the Attribute.This follows the same for all