My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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