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!
Group results of saved search to control balance
Hi Team,
I need help to see if I can handle a saved search to control balance.
I have a saved search where I look into transactions lines.
One of my columns is "balance" where I want to see if there's any balance to this line.
I.e.:
Line 1 - Amount 5000
Line 2 - Amount -3000
Line 3 - Amount -2500
Sum of these three lines = -500
But what my user needs is to have this rule: If sum of lines < 0, then show 0, otherwise shows the sum. Is there a way I can add this summary condition?