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!
Error with output type - Output format ANY
Hi All,
I am having an issue with a formula where I am getting the error "The output type of the formula is set to STRING, but the actual return type is ANY. Please change either the formula expression or the output type."
it is a simple case statement that works fine as a Formula(text) in saved search which returns a value if it finds a specific value within the name. The name is alphanumeric.
CASE WHEN ({billofmaterials.name}) like '%24100%' THEN '24' ELSE NULL END
Any help would be appreciated