SHIP DAYS passed or COMPLETED in the CURRENT MONTH

[former_member666725]

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 or Completed in the current month from 1st date of the current 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).

Example : - 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" key figure 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" to find "Daily Average Sales Qty – Month To Date".

Month to Date calculation.

Experts please suggest on this if you know the solution on similar scenarios.

Thanks in advance

[piyush_parekh · Accepted solution]

Hi,

Here is my suggestion:

1. Assuming Demand History Qty Adjusted is at PRODLOCCUST level, create a stored key figure KF1 at DAYPRODLOCCUST and populate 1 in each period for all combinations via CPI or IBP.

2. Create a calculated key figure KF2 and add a calculation definition with logic - if PERIODID0 < $PERIODID0CU$, then KF2 = KF1 else 0. This will populate the value 1 in all past periods (excluding current period) Here 0 in PERIODID0 represents day level.

3. Add another calculation in this key figure to aggregate the data at TW level -

KF2@WKPRODLOCCUST = SUM(KF2@DAYPRODLOCCUST)

4. Use another key figure to aggregate KF2 to MTH level.

KF3@WKPRODLOCCUST = KF2@WKPRODLOCCUST

KF3@MTHPRODLOCCUST = SUM(KF3@WKPRODLOCCUST)

5. Create a target key figure which will represent "Ship days passed up to the current date", say KF4 and add a calculation - KF4@MTHPRODLOCCUST = KF3@MTHPRODLOCCUST. You can use this key figure to find out the daily average.

Please refer to SAP IBP model configuration guide - key figure section to get an idea on exact syntax used while defining a key figure calculation.

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/1908/en-US/78da2d554c95743ce10000000a17...

Hope this helps!

Regards,

Piyush