I need to find a way to change the way the grand total is being calculated for one of my fields. I have attached a picture so I could explain what I want better. The red values is what I'm currently getting the purple values is what I'm after. the ASM_WEIGHT_T and Hours are bound field and Tons/Hour is and unbound field.
|
|
|
NON VALUE
|
VALUE
|
Grand Total
|
|
|
|
|
|
ASM_WEIGHT_T
|
Hours
|
Hour/Tons
|
ASM_WEIGHT_T
|
Hours
|
Hour/Tons
|
ASM_WEIGHT_T
|
Hours
|
Hour/Tons
|
|
|
|
324
|
324442
|
0.30
|
2.50
|
8.43
|
0.30
|
19.50
|
65.76
|
0.59
|
22.00
|
74.20
|
37.10
|
|
|
324444
|
2.92
|
6.00
|
2.06
|
2.92
|
48.75
|
16.70
|
5.84
|
54.75
|
18.76
|
9.38
|
|
|
324445
|
1.56
|
2.00
|
1.28
|
1.56
|
17.25
|
11.05
|
3.12
|
19.25
|
12.33
|
6.16
|
|
|
324446
|
2.83
|
4.00
|
1.41
|
2.83
|
21.25
|
7.50
|
5.67
|
25.25
|
8.91
|
4.46
|
|
|
324448
|
0.26
|
0.50
|
1.91
|
0.26
|
3.75
|
14.29
|
0.52
|
4.25
|
16.20
|
8.10
|
|
|
324449
|
19.73
|
30.00
|
1.52
|
19.73
|
96.50
|
4.89
|
39.46
|
126.50
|
6.41
|
3.21
|
|
|
324451
|
31.89
|
39.50
|
1.24
|
31.89
|
288.50
|
9.05
|
63.78
|
328.00
|
10.29
|
5.14
|
|
|
324452
|
0.82
|
3.50
|
4.25
|
0.82
|
6.75
|
8.19
|
1.65
|
10.25
|
12.44
|
6.22
|
|
|
324453
|
4.53
|
19.00
|
4.20
|
4.53
|
144.75
|
31.98
|
9.05
|
163.75
|
36.18
|
18.09
|
|
|
324457
|
16.16
|
6.25
|
0.39
|
16.16
|
14.50
|
0.90
|
32.32
|
20.75
|
1.28
|
0.64
|
|
|
324463
|
22.05
|
26.50
|
1.20
|
22.05
|
53.75
|
2.44
|
44.11
|
80.25
|
3.64
|
1.82
|
|
|
324464
|
2.27
|
5.50
|
2.42
|
2.27
|
27.00
|
11.90
|
4.54
|
32.50
|
14.32
|
7.16
|
|
|
324465
|
0.12
|
0.50
|
4.07
|
0.12
|
0.50
|
4.07
|
0.25
|
1.00
|
8.14
|
4.07
|
|
|
324466
|
7.25
|
9.75
|
1.35
|
7.25
|
21.75
|
3.00
|
14.50
|
31.50
|
4.35
|
2.17
|
|
|
324467
|
0.85
|
3.00
|
3.55
|
0.85
|
21.25
|
25.12
|
1.69
|
24.25
|
28.66
|
14.33
|
|
|
324468
|
2.38
|
6.75
|
2.84
|
2.38
|
23.25
|
9.78
|
4.75
|
30.00
|
12.62
|
6.31
|
|
|
324469
|
17.37
|
17.75
|
1.02
|
17.37
|
94.75
|
5.45
|
34.75
|
112.50
|
6.47
|
3.24
|
|
|
324470
|
3.99
|
3.00
|
0.75
|
3.99
|
59.25
|
14.85
|
7.98
|
62.25
|
|