You need to sign in to do that
Don't have an account?
Sreejith Kalarikkal
Validation rule Syntax error
NOT (ISPICKVAL( Transfer_ID__r.Transfer_Type__c , 'Store to WHS') AND (Shipping_Quantity__c > Serial_No__r.Quantity_available__c ))
I am getting ) missing in thie validation rule, Can someone help?
I am getting ) missing in thie validation rule, Can someone help?
Please try this,
NOT(
AND(
ISPICKVAL( Transfer_ID__r.Transfer_Type__c , 'Store to WHS'),
(Shipping_Quantity__c > Serial_No__r.Quantity_available__c )
)
)
The syntax for AND operator is AND(Boolean exp 1, Boolean exp2)
Try this below code.
NOT (
AND (
ISPICKVAL( Transfer_ID__r.Transfer_Type__c , 'Store to WHS') ,(Shipping_Quantity__c > Serial_No__r.Quantity_available__c )
)
)
Thie syntax is : NOT( AND (ISPICKVAL(VAL1) , VAL2 ) )
NOT (ISPICKVAL( Transfer_ID__r.Transfer_Type__c , 'Store to WHS')) &&
NOT((Shipping_Quantity__c > Serial_No__r.Quantity_available__c ))
You missing the first bracket of NOT.
Try else let me know.