Monthly Budgeted amount into weeks Accumulated

WernerDC — Fri, 13 Aug 2021 06:46:45 GMT

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

topic Monthly Budgeted amount into weeks Accumulated in App Development