please help with expression

[MarioNZ]

Hi All,

Please could you assist with this expression: the correct answer should be 2.47 wks but i keep getting 2.85 wks

If i activate the 'Sum of ROWS' function under 'Total Mode' in the expression tab - i get the correct answer.

However i do not want to 'overide' the function as i need the correct answer to reflect in the calculated text object as well

Sum([Total Hours Taken (Leave)])/Avg([Hours - 4 Week Average])

At a line level all the values are correct - but the sum values for 'Leave Taken - 4' and 'Leave Balances - 4' are incorrect 

Leave Accrued	Leave Taken - 4	Leave Balances - 4
3.62 wks	2.85 wks	0.77 wks
0.08 wks	0.00 wks	0.08 wks
0.15 wks	0.00 wks	0.15 wks
0.23 wks	0.00 wks	0.23 wks
0.31 wks	0.00 wks	0.31 wks
0.38 wks	0.00 wks	0.38 wks
0.46 wks	0.00 wks	0.46 wks
0.54 wks	0.00 wks	0.54 wks
0.62 wks	0.00 wks	0.62 wks
0.69 wks	0.00 wks	0.69 wks
0.77 wks	0.00 wks	0.77 wks
0.85 wks	0.00 wks	0.85 wks
0.92 wks	0.00 wks	0.92 wks
1.00 wks	0.00 wks	1.00 wks
1.08 wks	0.00 wks	1.08 wks
1.15 wks	0.00 wks	1.15 wks
1.23 wks	0.00 wks	1.23 wks
1.31 wks	0.00 wks	1.31 wks
1.38 wks	0.00 wks	1.38 wks
1.46 wks	0.00 wks	1.46 wks
1.54 wks	0.00 wks	1.54 wks
1.62 wks	0.17 wks	1.45 wks
1.69 wks	0.00 wks	1.53 wks
1.77 wks	0.15 wks	1.45 wks
1.85 wks	0.00 wks	1.52 wks
1.92 wks	0.00 wks	1.60 wks
2.00 wks	0.00 wks	1.68 wks
2.08 wks	0.00 wks	1.76 wks
2.15 wks	0.00 wks	1.83 wks
2.23 wks	0.00 wks	1.91 wks
2.31 wks	0.00 wks	1.99 wks
2.38 wks	0.00 wks	2.06 wks
2.46 wks	0.00 wks	2.14 wks
2.54 wks	0.00 wks	2.22 wks
2.62 wks	0.00 wks	2.29 wks
2.69 wks	0.09 wks	2.28 wks
2.77 wks	0.00 wks	2.36 wks
2.85 wks	0.12 wks	2.32 wks
2.92 wks	0.00 wks	2.40 wks
3.00 wks	0.00 wks	2.47 wks
3.08 wks	0.60 wks	1.95 wks
3.15 wks	0.11 wks	1.92 wks
3.23 wks	0.00 wks	1.99 wks
3.31 wks	0.00 wks	2.07 wks
3.38 wks	0.00 wks	2.15 wks
3.46 wks	0.17 wks	2.06 wks
3.54 wks	0.70 wks	1.43 wks
3.62 wks	0.36 wks	1.15 wks

[MarioNZ · Accepted solution]

Fixed in script - thanks!!