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

Can SQl case statement calculations be used as filters in NSAW?

&gt;*AI generated answer (using internal Slack threads):*
Based on the conversations provided, it appears that SQL `CASE` statements can be used in NetSuite SuiteAnalytics (NSAW) for calculations, but there is no explicit mention of using them as filters. One user suggests using a `CASE` statement in a Formula (Numeric) field and setting the formula to equal 1 as a workaround for filtering. However, this is not a direct use of a `CASE` statement as a filter in NSAW.

Here is the suggested workaround:
``` 
CASE WHEN {city} = 'Paris' THEN 1 WHEN {city} = 'London' THEN 1 ELSE 0 END
```
This formula would return 1 for records where the city is either 'Paris' or 'London', and 0 for all other records. You could then filter on this formula to only include records where the formula equals 1.

******
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/C298P0BCK/p1709683318580199|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.806558132

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

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



Please provide your feedback on this answer.