Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Boolean Formula in Analytics Dataset
I'm trying to create a Boolean formula in an Analytics dataset and no matter what I do I'm getting an error:
"You have syntax error in your formula (Unsupported element: Element does not exist or element class SqlValueContainer is expected.). Please see the documentation for supported syntax. (Error on line 1 column 1.)"
Even comparing a value to itself throws this error, like: {partner#display} = {partner#display}. The field is valid because running CASE WHEN {partner#display} = {partner#display} THEN 'T' ELSE 'F' END as a string formula validates fine.
I don't see any boolean examples in SuiteAnswers. Please help.