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!
Can I simpify this SQL??
In a saved search I have a formula currency entry with a big SQL statement that I'd like to simplify - the first way should work but I'm wondering if I can do something like the second way to simplify it?
Option 1 - I have something similar working
case when condition 1 and cond 2 and cond 3 and A then $xxx when condition 1 and cond 2 and cond 3 and B then $xx when condition 1 and cond 2 and cond 3 and C then $xx else $0m end
ie you can see that I need to always use the same first 3 conditions joined with an extra condition, I'm looking for a way to put the 3 same conditions just once in the query so below is what I'd like to do but it doesn't work, any help would be appreciated.