nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Child Item

Ask A Guru

Child Item

Sum of all values from different case when statements

User_76ANW

Hi,

I have different formulas (case when statements) per column in my saved search result but when I add a final column to get the total of all statements, I get an incorrect result.

Saved search: Item Usage per Month Rolling period

I'm expecting the sum of everything to be 100+ but it's only returning 25.

Is there any reason why?

Find more posts tagged with

item

formula

Sales Order

saved search

case when

Component react.asset.answerThread had an error.

You are not allowed to view comments.

Child Item

Upcoming Events

SuiteWorld | October 25–28, 2026 | Las Vegas
Big ideas. No travel required. SuiteWorld On Air brings the best of SuiteWorld directly to you. Stream keynotes live, access exclusive virtual content, and connect with the NetSuite community from wherever you are. Explore what's next for NetSuite, see AI innovation in action, and discover practical insights designed to…
What's Next for Product Companies with NetSuite
WEBINAR What's Next for Product Companies with NetSuite See how NetSuite Next uses AI to improve accuracy and protect margins Ask. Understand. Act. Use Ask Oracle to search, navigate, analyze business data, surface insights, get guidance, and take action using natural language—all through a single conversational…
Learning Lab | Cincinnati
Drive better outcomes with AI built into NetSuite Next The Lytle Park Hotel, Autograph Collection,311 Pike St, Cincinnati, OH 45202 Join NetSuite experts for a free half-day event where you'll learn how to use Al, automation, and our latest product innovations to optimize NetSuite for your business. At this event, you’ll:…
Inside the Suite | Cincinnati
Take NetSuite Next for a hands-on test drive The Lytle Park Hotel, Autograph Collection, 311 Pike St, Cincinnati, OH 45202 What to expect: Inside the Suite is designed for companies exploring modern ERP solutions. This event gives you the opportunity to experience NetSuite Next—the next evolution of NetSuite that brings AI…

More events