This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

i need a formula for workbook analytics that displays UK if the shipping country is the United Kingdom and International if not

&gt;*AI generated answer (using internal Slack threads):*
Based on the conversations provided, you can create a formula in NetSuite that checks the shipping country and displays "UK" if the shipping country is the United Kingdom and "International" if not. 

Here is a sample formula that you can use:

```CASE WHEN {shipcountry} = 'United Kingdom' THEN 'UK' ELSE 'International' END```

This formula uses the `CASE WHEN` statement to check the value of the `shipcountry` field. If the value is 'United Kingdom', it returns 'UK'. If the value is anything else, it returns 'International'.

Please replace `{shipcountry}` with the actual field id of the shipping country in your NetSuite environment.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1693502541253379|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.803976059

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C29HKGM6J/p1631571138054700|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.799882829

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1647545973436599|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.798940778



Please provide your feedback on this answer.