I have created column validation to enter only positive integers with 2 decimal. But I'm unable to key in integers with decimal. I'm not sure what went wrong.
Column validation formula. :
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
Your second logical function is failing and it is always returning false, hence column validation failed.
INT function will round off number to nearest integer. So
INT(1.11) = 1
Hence in formula, comparing is happening like
1 = 1.11 which is returning false and column validation failing.
Sharepoint field type of "Number" do not have your expected validation. Only way to acheive this either of the below two types
Have your own custom field, In that you can override getvalidatedstring method to add your requirement validation
You can multiply the “Unit Price” by 100, then check if it is an integer.
=AND(SIGN([Unit Price($)])>-1,INT([Unit Price($)]*100)=[Unit Price($)]*100)