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.
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
Add comment