more help with Rolling Balance logic

MarioNZ — Wed, 25 Nov 2020 16:16:04 GMT

I would appreciate some assistance, as i keep getting stuck with calculation of rolling balances.

The following is employee data for hours worked on a Monday across several periods.

I need to calculate the MEDIAN and the AVERAGE across several periods, 4 , 13, 24, and 52

However, when applying the following calculation, i seem to get the same answer for all reference periods - 8.50 Median and 6.38 Average

RangeAvg(Above(Median([Monday (Worked)]), 0, 4))

RangeAvg(Above(Median([Monday (Worked)]), 0, 13))

RangeAvg(Above(Median([Monday (Worked)]), 0, 24))

RangeAvg(Above(Median([Monday (Worked)]), 0, 52))

RangeAvg(Above(Avg([Monday (Worked)]), 0, 4))

RangeAvg(Above(Avg([Monday (Worked)]), 0, 13))

RangeAvg(Above(Avg([Monday (Worked)]), 0, 24))

RangeAvg(Above(Avg([Monday (Worked)]), 0, 52))

I should be getting the following answers below:

# of pay periods	Monday (Worked)	Median	Average
1	0.0
2	9.0
3	8.5
4	9.0	8.75	6.63
5	9.0
6	8.3
7	8.5
8	9.0
9	4.3
10	10.3
11	10.3
12	8.8
13	9.3	9.00	8.00
14	4.5
15	0.0
16	8.8
17	9.0
18	9.3
19	9.0
20	4.5
21	4.0
22	9.0
23	9.3
24	8.8	8.88	7.50
25	3.0
26	3.0
27	0.8
28	2.0
29	1.5
30	3.5
31	7.0
32	9.0
33	9.0
34	8.8
35	4.0
36	8.5
37	9.0
38	9.0
39	4.8
40	0.0
41	0.0
42	8.0
43	3.5	8.50	6.38

Re: more help with Rolling Balance logic

sunny_talwar — Wed, 24 Jul 2019 11:49:43 GMT

Is this what you need

Re: more help with Rolling Balance logic

Brett_Bleess — Wed, 14 Aug 2019 21:43:51 GMT

Mark, did Sunny's post help you get things working as you wished? If so, please be sure to circle back here and click the Accept as Solution button on his reply to give him credit for the help. If you used something else, it would be helpful to others to post that and mark that as the solution. If you still require further assistance, provide an update of where you stand.

Regards,
Brett

topic more help with Rolling Balance logic in QlikView

more help with Rolling Balance logic

Re: more help with Rolling Balance logic

Re: more help with Rolling Balance logic