Skip to main content
Topics#FormulasFrage von Chad Coffey
Chad Coffey fragte in #Formulas
2. März 2018, 14:05

Validation to only allow whole numbers

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))
7 Antworten
  1. Chad Coffey
    5. März 2018, 18:55
    Sorry for any confusion.  The field  jstcl__Burden__c is a percentage field with 2 decimals.  This is a managed field by one of our vendors so I cannot simply change the Decimal Places to 0.  We need to disallow our users from entering a value such as 25.25%.  They should only enter a value such as 25 or 20.  The system will automatically turn the 25 & 20 into 25.00 and 20.00.  Essentially we need the two decimal places (hundredths/thousands) to = .00. 

     
Slack-Logo