Forum Stats

  • 3,686,721 Users
  • 61,100 Discussions
  • 206,397 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
Virtual Event: Getting the Most Out of NetSuite Standard Costing Capabilities

You asked for it, you got it! Join the webinar Getting the Most out of NetSuite Standard Costing Capabilities on June 28, 2022 at 11AM PT. Register here!

WATCH: Saved Search to Combine Two Case When Statements in Criteria

This is a How-to video on creating a Saved Search with criteria combining two case when statements.

Here is the formula used in the video presentation:

  • CASE WHEN {shipdate} BETWEEN to_date ('7/01/2019', 'mm/dd/yyyy') AND to_date ('7/31/2019', 'mm/dd/yyyy') THEN (case when {status} = 'Pending Fulfillment' then ({amount}) else 0 end) ELSE 0 END

Description: not equal to 0

Kindly mark "Yes" if you find the reply to your question as helpful. This will aid the community to find the solution/answer much easier. Let's always mark a reply and help the community! ☺️

Shamaine Chan-Oracle | Ask a Guru

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders