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

Question: In Demand Management, How to use Moving_Total Function to exclude past 2 weeks while per

Received Response


Hi Team,

We have an requirement to do Moving_Total for 'demand' for Past 12 weeks. But immediate past 2 weeks should not be included in moving_total summation.

For Ex: If current week is 2/19/2024 then moving_total should be done for past 12 weeks excluding the immediate weeks from 2/5/2024 and 2/12/2024.

can you please suggest on this requirement to how to use this function or use any other function

Content (please ensure you mask any confidential information):

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

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

Howdy, Stranger!

Log In

To view full details, sign in.


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