Hi,
I am not able to pass the above module.
Here is my code:
AND( ISPICKVAL(Support_Tier__c , "Gold"), AnnualRevenue < (20 * $CustomMetadata.Support_Tier__mdt.Gold.Minimum_Spending__c) )
However, when I click on the "Check Challenge", it feedback the following the message:
Challenge not yet complete in Cunning Raccoon Playground
In the validation rule named 'Revenue_Validation', we can’t find a reference to '$CustomMetadata.Support_Tier__mdt.Gold.Minimum_Spending__c'.
I have cleared the cache, as well as using another browser, and I still encountered the same issue.
Please advise how shall I proceed.
Regards.
Hi @Taw Sern Tan I used your formula in the validation rule & got the same error.
Then, I went through the module again and you can see they have given a below validation rule
IF(
(ISPICKVAL( Support_Tier__c , "Silver")
&&
( Total_Spending__c <
$CustomMetadata.Support_Tier__mdt.Silver.Minimum_Spending__c
)
)
||
(ISPICKVAL( Support_Tier__c , "Gold")
&&
( Total_Spending__c <
$CustomMetadata.Support_Tier__mdt.Gold.Minimum_Spending__c
)
), TRUE, FALSE
)
I took this and made change according to the challenge, like below and it worked.
IF(
(ISPICKVAL( Support_Tier__c , "Gold")
&&
( AnnualRevenue <
20*$CustomMetadata.Support_Tier__mdt.Gold.Minimum_Spending__c
)
), TRUE, FALSE
)
