Anyone can please help me out with time series calculation in NSAW, I want to achieve MTD and YTD columns based on transaction date but I am stuck with errors. I am using Custome Invoice as the Subject are, Pulling out the "NetSuite - Customer Invoice"."Transaction Attributes"."Customer Invoice Transaction Date", to use in AGO function, In time level I am adding Month and the offset is set to 1. But System is displaying error. Requesting if someone could enlighten me by highlighting what went wrong. I have already gone throught User Manuals, ChatGPT, Claude and Gemini. But all are showing the same kinda formula. #help #C08JWFW60H0 #community

I've had trouble with this in the past, but am about to redo our NSAW stuff based on the new OAC release features. These helped me: https://docs.oracle.com/en/cloud/paas/analytics-cloud/tutorial-time-calcs/index.html And the parameters portion of this Oracle looks very promising:

Thank you so much @Mark C