You need to sign in to do that
Don't have an account?
Lukasz Piziak
Validation Rule on Roll-Up Summary
Hello,
I'm looking for help with creation the Validation Rule based on Status field (Picklist) and Roll-Up Summary field. Basically I would like to avoid user approving the record when the SCMC__Total_Value_of_PO__c is equal zero. I have creatwd the following formula, but system is allowing me to approve the record, please see below:
AND(
ISPICKVAL(SCMC__Status__c,"Approved"),
ISNULL( SCMC__Total_Value_of_PO__c)
)
When there is no value on Roll-Up Summary field the following data is displayed; EUR 0.00.
Thanks for any advise.
Regards
Lukasz
I'm looking for help with creation the Validation Rule based on Status field (Picklist) and Roll-Up Summary field. Basically I would like to avoid user approving the record when the SCMC__Total_Value_of_PO__c is equal zero. I have creatwd the following formula, but system is allowing me to approve the record, please see below:
AND(
ISPICKVAL(SCMC__Status__c,"Approved"),
ISNULL( SCMC__Total_Value_of_PO__c)
)
When there is no value on Roll-Up Summary field the following data is displayed; EUR 0.00.
Thanks for any advise.
Regards
Lukasz
Since validation rules executes before your approval action this will not stop the approval process. Inorder to induce error and stop approval action based on criteria you need to write a trigger.