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!
Need to sum a formula but ignore duplicate numbers
I have a saved transaction search that is running a custom sales report and we need to include budget fields. Everything works except the budget is being multiplied by how many transactions are included, since the result is appearing in every line. There is a budget for every month, and I'm trying to get the total budget for that line year to date.
So basically I need to have a formula that sums the budget but only using one budget number per month.
Here's what my current formula looks like (simplified):
decode({transaction_month},{budget_month},{budget_amount},0)
0