I have a sumed value , field value, (see table 1 in the excel file attached below) , and i need to allocate it according to the same dimensions but also on the list of working days betwwen start-date and end-date (allocating value/[Nbdays]) and then sum it
(see table result). for the other days (wekends and holidays) we'll just put zero instead.
I have already a calendar with a flag (if the date is a workingday than 1 else 0).
You can do this by using a while-loop, where the while loops between start date and end date. Then you can create a daily amount based on initial number and how many days you have in this range,
.png "Former Employee"){kind=icon}