My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Comments
-
Hey Niks, Apologies I was away on vacation. The NS_Concat solution worked - thank you for helping me find the solution!
-
Update: I was able to figure it out - correct formula is CASE WHEN {trandate} BETWEEN TO_DATE('01/01/2023','MM/DD/YYYY') AND TO_DATE('06/30/2023','MM/DD/YYYY') THEN {totalamount} ELSE 0 END
-
Hey @Tris Mendoza-Oracle Thanks for reaching out! The date filter in criteria is just to shrink the report size while I am testing. See attached