Skip to main content

Mar 2, 2018, 5:04 PM

Validation to not allow decimals

I am working on a validation on a number field that is apart of a managed package so we cannot change the number of decimals. I need to the field to always have a whole number entered. The validation I have below, works for the most part, except when 10,20,30 are entered. The Validation work corrects when 15,25, etc are entered. Any help?

AND(

NOT(REGEX(TEXT( jstcl__Burden__c ), "[0-9]+[.]{1}[0-9]{2}")),

NOT( jstcl__Burden__c =0))

4 answers

Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
Mar 2, 2018, 5:48 PM
So the only restriction is that it should be Whole Number(Not Allow Decimals) ?

How about this =
(jstcl__Burden__c - FLOOR(jstcl__Burden__c)) <> 0

Add a comment

Write an answer...

0/9000