Hi Team,
I need some quick help in analysing below data.
In my process, there is one input sheet which is updated every month and used in the workflow.
Explanation:
1.When we place the above input file and run the process for January, it should reflect data for January month. February data should be average of January data.
Points | Months | Values |
A | January | 25 |
A | February | 25 |
A | March | 0 |
A | April | 0 |
A | May | 0 |
A | June | 0 |
A | July | 0 |
A | August | 0 |
A | September | 0 |
A | October | 0 |
A | November | 0 |
A | December | 0 |
2. When we run the process for February using updated input file in Feb,new Feb data will be reflected.
March data will be average of Jan and Feb data.
Points | Months | Values |
A | January | 25 |
A | February | 5 |
A | March | 15 |
A | April | 0 |
A | May | 0 |
A | June | 0 |
A | July | 0 |
A | August | 0 |
A | September | 0 |
A | October | 0 |
A | November | 0 |
A | December | 0 |
3. Similarly when we run the process for March using updated input file, new March data will be reflected.
April data will average of Jan,Feb and March data
Points | Months | Values |
A | January | 25 |
A | February | 5 |
A | March | 10 |
A | April | 13.33 |
A | May | 0 |
A | June | 0 |
A | July | 0 |
A | August | 0 |
A | September | 0 |
A | October | 0 |
A | November | 0 |
A | December | 0 |
Kindly help.
Thanks in advance:)
Also,I want it to be done through calender option.
Thanks
Can anyone please help on above issue?