Hi Parthi,
You can follow the below steps in order to calculate the passed ship Days
1) You can create an attribute as a key figure(KF1) and default it to 1 so that this key figure will have 1 value across the entire horizon.
2) Create another key figure(KF2) in order to determine the number of passed periods
3) Now add the below calculation in order to aggregate the data at the TW Level
ZKF2@WKPRODLOC = SUM( "ZKF2 @DAYPRODLOC" )4) Add another calculation in order to aggregate the data at MTH Level
ZKF2@MTHPRODLOCCAL = SUM( "ZKF2 @WKPRODLOC" )For ex on 20th Sept the Passed Ship Days should be 19
Regards
Arif
Hi Parthi, could you please elaborate what is the use case for Current date for you.
In calculations expression : PERIODIDn is sed : n is the time period level so if you have a time profile with base as Month and then Quarter and year. then PERIODID0 = Month, PERIODID1 = YEAR and PERIODID2 = month. for Current period the expression is $$PERIODIDnCU$$ . This should help for the required calculations. Please refer to SAP documentation here:
Please let me know if this does not solve your problem.
Thanks,
Nikunj
The requirement is to find out the "Daily Average Sales Qty - Month To Date" = Demand History Qty Adjusted / number of “Ship Days” passed up to Current Date
(Excluding current date ie. To day)
The requirement is to find out how many "Ship Days" have passed / Completed in the current month from 1st date of the month to current date (Excluding current date - To day).
How to find the number of "Ship days" passed from the beginning of this month to till yesterday (Not current date).
IF we are in the middle of the month on 19-Sep-2019 and user enters the adjusted Sales qty in "Demand History Qty Adjusted" for Sep-2019 cell in the Planning View then We would like to calculate the "Demand History Qty Adjusted" divided by the number of "Ship days passed up to the current date".
Month to Date calculation.
Experts please suggest on this if you know the solution on similar scenarios.
Thanks in advance
Add comment