Number formula conditoned by a picklist

Question

Hello everyone,

I am a new admin, learning on the go and of course, I am stuck with an issue :)

here is what I am trying to achieve:

I would like to add 19% to a number field, only if a Picklist field value is "Germany"

if you need more detail, shoot, and thank you all in advance

Amnon Kruvi · Accepted Answer

+Om

However, if you suspect you might have similar increases in the future for other countries, the following format might be more future-proof:

MyNumberField__c * 
CASE(MyPicklist__c,
"Germany", 1.19,
1)

You could then add additional countries with their own values right after the line that says Germany.

Amin Ahcene · Answer

Thank you it works, and good move by thinking to the future :)

Data Management