I'm trying to create a formula which will show a % of new accounts by region, against a target. The target isn't native to Salesforce and will differ depending on the what the picklist value is. The values and targets are below
If HQ Region = 'Europe' / 20 * 100
If HQ Region = 'Africa' / 4* 100
If HQ Region = 'Asia' / 2* 100
If HQ Region = 'Oceania' / 3* 100
If HQ Region = 'North America' / 15* 100
If HQ Region = 'Latin America' / 3* 100
I'm going around in circles so any help would be much appreciated!
8 件の回答
Hi Katherine,
CASE(HQ Region,
"Europe",20 * 100,
"Africa", 4* 100,
"Asia", 2* 100,
NULL)
Like wise for other value.
Thanks,
Amit Trivedi
