Calculation of Ratios

[Naila]

Hi guys. I need your help my difficulties with Alteryx. So I add tables below which exists and which I need:

Now

indicators	july	august	september	october	november	december	january	february	march
Leavers	5	7	1	0	8	6	12	4	0
Average num of employees	244	245	244	242	248	244	243	242	245
Total num of employees	320	324	322	318	320	322	325	321	320

Expected

indicators	july	august	september	october	november	december	january	february	march
Job leaving ratio	leavers/Average num of employees	leavers/Average num of employees	leavers/Average num of employees	leavers/Average num of employees	leavers/Average num of employees	leavers/Average num of employees	leavers/Average num of employees	leavers/Average num of employees	leavers/Average num of employees
Job leaving ratio rolling base	Sum of Leavers(november:july)/Average of total employees (october:july)	Sum of Leavers(december:august)/Average of total employees (november:august)	Sum of Leavers(february:september)/Average of total employees (january:september)	Sum of Leavers(march:october)/Average of total employees (february:october)	Sum of Leavers(april:november)/Average of total employees (march:november)	Sum of Leavers(may:december)/Average of total employees (april:december)	Sum of Leavers(june:january)/Average of total employees (may:january)	Sum of Leavers(july:february)/Average of total employees (june:february)	Sum of Leavers(august:march)/Average of total employees (july:march)

I hope I`ll find solution here. Thanks in advance!

[apathetichell]

Honestly this was a bit messy but this is what I got.

I also did not loop it as you did in your month count. If you want it looped reupload it as an excel or alteryx workflow and provide a starting date and more column. If you want to loop it you can do a mod division system or a much simpler date base system.