ALL the code:
AND (
AND(
ProductCode__c = "CA-38",
SUM (Amount__c) > 0
)
,
AND(
ProductCode__c = "AD-Y-11",
ProductCode__c = "AD-Y-12",
ProductCode__c = "AD-Y-13",
ProductCode__c = "AD-Y-14" ,
NOT ( SUM (Amount__c) > 0 )
)
)
Hi team,
Someone to help me.
I want a rule that prevents the sum of specific products from being equal to zero.
#Trailhead Challenges
10 answers
@Ohou Jean-Luc Soboh You'll need to create a Flow to accomplish this, as a formula or validation rule alone can't retrieve specific product records and sum their amounts. In the Flow, use the **Get Records** element to fetch the amounts for multiple products, aggregate them, and check if the total exceeds zero.