Good day Fellow Qlickers.
Hope someone can help me with the following:
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?
Kind regards