Forum Discussion
Center Utilization Per Month 445 period
Hello Below is the table I am trying to calculate the weekly center utilisation summed monthly. And the PIBX at the bottom. Centre Name Manager Daily Capacity Week 30/12/19 Week 6/01/2...
RobbeVL
Impactful Individual
Impactful IndividualHi,
You will first need to remodel your data in order to perform usefull calculations.
I've performed this is the example file here.
How do you identify this period? Your examle file contained multiple periods together, this is 4-4-5 ?
Robbe
Hello RobbeVL
I downloaded your sample thank you.
The pibx I shared has the table relation for the dates using "Calendar WeekNumber". What I was trying to do was to sum the weeks aggregated by month ussing the 445 accounting peroids.