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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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?
0