Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to Copy quantity value for all days in a given period

Hello Experts,

I have a requirement here, where a user gives the Quantity value for a period and that value should be copied to all the days of the given period, Please suggest on this.

I guess we can do it using Fox Formulas. Not sure

Thanks,

Former Member
Former Member replied

Hi,

The user will enter the value of the keyfigure through some input layout. That layout will be either accessed through planning folder or web interface. However, whatever may be the case, the solution is the same. Create a layout through which the user will enter the data for 12 months. Now the data will be stored with the dates as #. So, in the function, create 12 different conditions for 12 different months and for each month give the FROM value as # and the TO value as the dates for respective months.

So, For Jan, it will be from # to 31 days. For Feb, it will be from # to 29 days. And so on.

Please award points if helpful.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question