RJMNS
12/20/2024, 4:34 PMCeligo AI
12/20/2024, 4:34 PMAI generated answer (using internal Slack threads):In SuiteAnalytics, you can use the IN function in your Data Set formulas. The IN function is used to specify multiple values in a WHERE clause. The syntax for using the IN function is as follows:
CASE WHEN {value} IN (123, 456, 789) THEN 1 ELSE 0 END
In this example, the formula checks if the {value} is in the list (123, 456, 789). If it is, it returns 1, otherwise, it returns 0.
To use this in SuiteAnalytics, you would need to create a formula column. You can do this by selecting the 'New Formula' button at the top of the fields list in SuiteAnalytics. After entering your formula, you can validate it by clicking on the 'Validate' button.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
12/20/2024, 4:34 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827506781
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.826632798
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.82415241
Celigo AI
12/20/2024, 4:34 PM