Hello,
I have a formula that I need tweaked.
It is for a list of jurisdictions that I need the report to pull.
Problem I’ve been having is that I need to add additional jurisdictions, but I don’t want these new jurisdictions that I need to add to pull any cases with two particular business units.
How can I tweak the formula to show cases the current cases and exclude the business unit with the new jurisdictions that I need to add?
The current formula is:
=If([Country Table].[Country Name] InList(“Afghanistan”;“Alan Islands”;“Albania”;“Algeria”;“Armenia”;“Australia”;“Azerbaijan”;“Bahrain”;“Bangladesh”;“Belarus”;“Benin”;“Bhutan”;“Bosnia and Herzegovina”;“Botswana”;“Brunei”;“Bulgaria”;“Burkina Faso”;“Burundi”;“Cambodia”;“Cameroon”;“Central African Republic”;“Chad”;“Channel Islands”;“China”;“Comoros”;“Croatia”;“Cyprus”;“Democratic Republic of the Congo”;“Czech Republic”;“Denmark”;“East Timor”;“Djibouti”;“Egypt”;“Eritrea”;“Estonia”;“Ethiopia”;“Faroe Islands”;“Fiji”;“Finland”;“French Southern Territories”;“Gabon”;“Gambia”;“Georgia”;“Ghana”;“Gibraltar”;“Greece”;“Greenland”;“Guam”;“Guernsey”;“Guinea”;“Hong Kong”;“Hungary”;“Iceland”;“India”;“Indonesia”;“Iran”;“Iraq”;“Ireland”;“Isle Of Man”;“Israel”;“Ivory Coast (Cote d’Ivoire)”;“Japan”;“Jersey”;“Jordan”;“Kazakhstan”;“Kenya”;“Kribati”;“Kuwait”;“Kyrgyzstan”;“Laos”;“Latvia”;“Lebanon”;“Lesotho”;“Liberia”;“Libya”;“Liechtenstein”;“Lithuania”;“Macau”;“Macedonia”;“Madagascar”;“Malawi”;“Malaysia”;“Maldives”;“Mali”;“Marshall Islands”;“Mauritania”;“Mauritius”;“Mayotte (overseas department of France)”;"Micronesia, Federated states of ";“Moldova”;“Monaco”;“Mongolia”;“Montenegro”;“Morocco”;“Myanmar”;“Namibia”;“Nauru”;“Nepal”;“Netherlands”;“New Caledonia”;“New Zealand”;“Niger”;“Nigeria”;“Niue”;“Northern Mariana Islands”;“Norway”;“Oman”;“Pakistan”;"Palau ";“Palestine”;“Papua New Guinea”;“Philippines”;“Poland”;“Polynesia, French”;“Qatar”;“Republic of the Congo”;“Reunion (overseas department of France)”;“Romania”;“Rwanda”;“San Marino”;“Sao Tome and Principe”;“Saudi Arabia”;“Turkmenistan”;“Tuvalu”;“Uganda”;“Ukraine”;“United Arab Emirates”;“Uzbekistan”;“Vanuatu”;“Vatican City”;“Vietnam”;“Wallis and Futuna”;“Western Sahara”;“Yemen”;“Zambia”;“Zimbabwe”;“Seychelles”;“Sierra Leone”;“Singapore”;“Slovakia”;“Solomon islands”;“Somalia”;“South Africa”;“South Korea”;“Sri Lanka”;“Sudan”;“Swaziland”;“Switzerland”;“Sweden”;“Syria”;“Taiwan”;“Slovenia”;“Tajikistan”;“Tanzania”;“Thailand”;“Togo”;“Tonga”;“Tunisia”;“Turkey”;“Senegal”;“Serbia”;“Isle of Man”;“Austria”;“Belgium”;“France”;“Germany”;“Italy”;“Luxembourg”;“Russian Federation”;“Switzerland”;“Andorra”;“Angola”;“Cape Verde”;“Equatorial Guinea”;“Guinea-Bissau”;“Mozambique”);[Country Table].[Country Name])
Thank you,
Miriam
MHamid (BOB member since 2016-06-24)