Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jude Green 18Jude Green 18 

Validation rule with negative number criteria

Hi I am trying to create a validation rule on an opportunity where one of the criteria is a custom currency field Credit Note Value exceeding EUR-999. 
I can get it work on opps where the value is above zero, so is this even possible to work with all negative numbers eg 
Credit_Note_Value__c < -1000)
Any help much appreciated
Jude
Best Answer chosen by Jude Green 18
mukesh guptamukesh gupta
Hi Jude,

Please try with 

ABS(Credit_Note_Value__c) < - 1000

if you need any assistanse, Please let me know!!

Kindly mark my solution as the best answer if it helps you.

Thanks
Mukesh

All Answers

mukesh guptamukesh gupta
Hi Jude,

Please try with 

ABS(Credit_Note_Value__c) < - 1000

if you need any assistanse, Please let me know!!

Kindly mark my solution as the best answer if it helps you.

Thanks
Mukesh
This was selected as the best answer
AnkaiahAnkaiah (Salesforce Developers) 
Hi,

when you should fire the validation rule?
Is it when user tries to enter -ve value more than 1000 ? 

If yes, try with below. 
ABS(Amount) >= -1000

If this helps, Please mark it as best answer.

Thanks!!