Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Case When X Then {field} error
Case When {account} = 'Revenue' Then {rate} Else '0' End
Anyone know why this causes an error. When I replace the {rate} with '1' it works properly. Must be something with the field value as an affirmative answer.
Nevermind, here is the answer:
The Else has '0' making it a text field. It is inconsistent with the affirmative outcome type {rate} which is currency. I removed the ' from the '0' and it worked.
0