X
AL
66
19732
X
AR
32
19732
X
AZ
1819
19732
X
CA
2011
19732
X
CT
3
19732
X
FL
64
19732
X
GA
29
19732
X
IA
2383
19732
X
IL
28
19732
X
IN
6239
19732
X
KS
99
19732
X
KY
65
19732
X
LA
1
19732
X
MA
1476
19732
X
MD
9
19732
X
ME
3
19732
X
MI
1767
19732
X
MN
10
19732
X
MO
12
19732
X
MS
211
19732
X
MT
19
19732
X
NC
77
19732
X
ND
9
19732
X
NE
1
19732
X
NJ
115
19732
X
NY
241
19732
X
OH
90
19732
X
OR
15
19732
X
PA
2671
19732
X
RI
1
19732
X
TN
8
19732
X
TX
57
19732
X
VT
2
19732
X
WA
85
19732
X
WI
14
19732
% of Total = ([Value]/[Sum_Value])*100
% of Total (rounded) = Round([% of Total]...
Error
IF [Total Difference] > 0 THEN
[Difference] < 0
ELSE
[Difference] > 0
ENDIF
Custom
IF [Total Difference] > 0 THEN
[Difference] < 0
ELSE
[Difference] > 0
ENDIF
Difference Absolute - Descending
RecordID
1
Int32
6
0
RecordID
Correction
Double
8
Empty
0 THEN
-0.01
ELSE
0.01
ENDIF
ELSE
0
ENDIF
]]>
IF RecordId/100 < ABS([Total Difference]) THEN
IF [Total Dif...
% of Total (rounded) = IF !IsNull([Correction]) THEN
[% of Total (rounded)] + [...
Warning
All
ByName
calculate total % rounded / not rounded
calculate difference
append difference to all rows
select "correction rows"
calculate absolute difference
order by absolute difference
add record id
add "rounding correction" to number of rows needed
add correction
calculate corrected value
Horizontal
%SUM-rounded