How to Copy quantity value for all days in a given period
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
Nilanjan Chatterjee replied
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.