Validation Rule for Profile and Currency Rate - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Mike WyandMike Wyand 

Validation Rule for Profile and Currency Rate

I am trying to force one Profile to select a differnet currency other than the default one. For example the default currency rate is USD but I want the force users in the Canada profile (Global Standard) to change to CAD. I tired this formula but it does not work.

AND($Profile.Name  = "Global Standard"),CURRENCYRATE("USA"))

This is the error -  Error: Syntax error. Extra ','

Thanks
Best Answer chosen by Mike Wyand
Tony TrinhTony Trinh
Hi Mike,

Give this a try:
AND(
$Profile.Name  = "Global Standard",
TEXT(CurrencyIsoCode) = "USD"
)

All Answers

Tony TrinhTony Trinh
Hi Mike,

Give this a try:
AND(
$Profile.Name  = "Global Standard",
TEXT(CurrencyIsoCode) = "USD"
)
This was selected as the best answer
Mike WyandMike Wyand
That worked.

Thanks Tony