We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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 one month while per

Received Response
21
Views
1
Comments
edited May 13, 2020 7:00AM in Supply Chain Planning and Collaboration 1 comment

Summary

Question: In Demand Management, How to use Moving_Total Function to exclude past one month while performing summation

Content

Hi Team,

We have an requirement to do Moving_Total for 'Final Shipments History' measure for Past 3 Months. But immediate past month should not be included in moving_total summation.

For Ex: If current month is May then moving_total should be done from Jan to March. (April month should not be included in Moving_total).

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

Thanks,

Ramesh

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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