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.
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