how to create custom Measure based on on-hand qty and total demand in Supply Planning

1:10PM

Summary:

requirement is to view actual onhad remaining each week.

how to create custom measure for The Logic in screenshot

Measure name : Actual_OnHand_Each_Week

value in Week 1: On Hand Start (500) - Demand (100) = 400
value in Week 2: Prior Result (400) - Demand (100) = 300
value in Week 3: Prior Result (300) - Demand (120) = 180
value in Week 4: Prior Result (180) - Demand (200) = -20

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):

how to create custom Measure based on on-hand qty and total demand in Supply Planning

Howdy, Stranger!