Number of days per month in SAP IBP

[Former Member]

Hi All,

I got a KF1@mthprodloc which has calculation like KF2@mthprodloc / Kf3@mthprodloc.

So Kf3 should count number of days in a month. How can we achieve this???

Regards,

Arun.S

[AyanBishnu · Accepted solution]

Hi Arun

You can achieve the result by following the below mentioned steps.

1) Kf3@mthprodloc should be editable in the present & future

2) In the excel view. goto EPM formatting and select the option " Keep Formulas"

3) Use the formula "=DAY(DATE(YEAR(D2),MONTH(D2)+1,))" on the cells for KF3.

4) the above formula will calculate the no of days in the current month.

[Former Member · Accepted solution]

Hi Ayan,

Could you please share screenshot was not able to locate option "keep formulas" in EPMformatting.

Appreciate your response.

Regards,

Arun.S

[Former Member · Accepted solution]

Hi Ayan,

Could you please show possibly with screenshot how you applied formula in EPMformatting that would be helpful.

I tried but somehow formula is not working and also i cannot see any values in the cell.

Thanks once again.

Regards,

Arun.S

[former_member228602]

Hello Arun,

One way i can think of from the backend is by using the Time profile attribute. In time you can assign an attribute to the Time period Month. This attribute can be number of days in the month. Once you do this you can assign this attribute to the planning level . Once assigned to the Planning level you can directly use this in the key figure calculation formula.

KF1@mthprodloc = KF2@mnthprodloc/DAYSMONTH where DAYSMONTH is a time profile attribute

Thanks and Regards,

Veera

[Former Member]

Hi Veera,

I tried your solution but in the attribute time period we need to pass on days value for that specific month and use that attribute in our calculation but do system calculate automatically in the background number of days for specific month??

Regards,

Arun.S