You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

3 Month Moving Average - Multiple Years

Received Response
111
Views
5
Comments
edited Oct 2, 2023 8:15PM in Planning 5 comments

Summary:


Content (required):

I am trying to calculate the average for the last 3 months and would like it to be a rolling average across years. I would like to add this an existing trend rule.

I looked up @MOVAVG, but am unfamiliar with this command and wasn't sure if that could cross years.

I also found the below code in an unused business rule but am also unfamiliar with it and was hoping for something not as long/complex. Any suggestions?


Version (include the version you are using, if applicable):

PBCS 23.09.68

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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