I have Budget values per month. I need to split this value equally into weeks and accumulate in to fit my current graph of accumulation.
Attached is a picture of the issue at hand (Screenshot 2021-08-13 at 08.32.57):
The black line (F2022 Budget) also needs to accumulate like the other 2 lines. Problem is that we budget per month. So I need to distribute the monthly amount evenly over the weeks of that said month and then let it accumulate.
Attached is a picture of the script where I pull in the Budget amount (Screenshot 2021-08-13 at 08.44.28):
I am more than happy to share the App if someone can help me?