Spreadsheet: 797730d1664108240-round-calculated-field-in-pivot-table-doesnt-give-precise-sum-totals-test-1-
Sheet: DATA

CARDHOLDER | BILLABLE_ENTITY_AMOUNT | [NAME] | CUSTOM_FIELD_LABEL - customField1 - Reason for Travel
[NAME] | 53.9 | 914150
SAni NAWAK | 246.47 | 908040 | Business
SAni NAWAK | 213.96 | 908040 | Business
SAni NAWAK | 21.44 | 908050 | Business
SAni NAWAK | 75.14 | 908050 | Business
AssAB AlAni | 16.99 | 914150
AssAB AlAni | 44.57 | 914150
SAni NAWAK | 73.01 | 908050 | Business
SAni NAWAK | 11.15 | 908050 | Business
SAni NAWAK | 24.26 | 908050 | Business
SAni NAWAK | 233.31 | 908050 | Business
SuvAl NAshiAch | 53.35 | 908050 | Business
SuvAl NAshiAch | 80.77 | 908050 | Business
SuvAl NAshiAch | 112.98 | 908050 | Business
SuvAl NAshiAch | 37.36 | 908050 | Business
SAni NAWAK | 350.41 | 908040 | Business
DAK NAHen | 109.47 | 908040 | Business
DAK NAHen | 170 | 908040 | Business
SAni NAWAK | 11.76 | 908050 | Business
SAni NAWAK | 40.13 | 908050 | Business
DAK NAHen | 101.86 | 908040 | Business
SuvAl NAshiAch | 53.22 | 908050 | Business
ANit AWKAn | 342.73 | 912000.97
SuvAl NAshiAch | 13.99 | 908050 | Business
SAni NAWAK | 186.18 | 908040 | Business
SuvAl NAshiAch | 223.07 | 908050 | Business
HilAd AEKAhAN | 539 | 908071
[NAME] AKKAuAs | 69 | 908040
DAK NAHen | 149.92 | 908020 | Business
DAK NAHen | 102.96 | 908040 | Business
SuvAl NAshiAch | 44.36 | 908050 | Business
SuvAl NAshiAch | 47.51 | 908050 | Business
SuvAl NAshiAch | 74.61 | 908050 | Business
HAdASA KABKi DAnAn | 59.5 | 908071
HAdASA KABKi DAnAn | 224.5 | 908071
DAK NAHen | 17 | 908050 | Business
DAK NAHen | 70 | 908050 | Business
NAAN AKAd | 65.49 | 908050 | Business
DAK NAHen | 128 | 908040 | Business
NAAN AKAd | 180.02 | 908050 | Business
SuvAl NAshiAch | 112.8 | 908050 | Business
NAAN AKAd | 17.21 | 908050 | Business
SAni NAWAK | 149 | 908010 | Business
SAni NAWAK | 149.5 | 908040 | Business
[NAME] EisneK | 1780 | 908071
ANit AWKAn | 452.8 | 908071
[NAME] | 86.9 | 908040
SuvAl NAshiAch | 66.69 | 908050 | Business
NAAN AKAd | 127.56 | 908050 | Business
SuvAl NAshiAch | 222.56 | 908050 | Business
Avi ShApiKA | 40 | 914170
IHAK HAv | 71 | 914170
NAAN AKAd | 102.24 | 908050 | Business
[NAME] | 100 | 908040
NAAN AKAd | 97.96 | 908050 | Business
HAdASA KABKi DAnAn | 47.8 | 914170 | TRAVEL
SuvAl NAshiAch | 46.97 | 908050 | Business
SuvAl NAshiAch | 98.36 | 908050 | Business
SuvAl NAshiAch | 25.67 | 908050 | Business
SuvAl NAshiAch | 115.38 | 908050 | Business
IHAK HAv | 40 | 914170 | TRAVEL
NAKiAh AWulAS | 883 | 908071
NAAN AKAd | 13.19 | 908050 | Business
KAi WiNAn | 106.2 | 908040
shiK.lichtiH . | 40 | 908040
NAK AiWenEeKH | 100 | 908040
WAhAK [NAME] | 40.4 | 908040
NAAN AKAd | 126.85 | 908050 | Business
KAi WiNAn | 74.7 | 908040
NAAN AKAd | 129.58 | 908040 | Business
SAHi-NAshe NSNAn | 972 | 909180.02
SuvAl NAshiAch | 283.4 | 908050 | Business
[NAME] | 50 | 914170 | TRAVEL
NAAN AKAd | 80.91 | 908050 | Business
SuvAl NAshiAch | 187.52 | 908040 | Business
SuvAl NAshiAch | 329.71 | 908040 | Business
SuvAl NAshiAch | 169 | 908010 | Business
NAAN AKAd | 273.73 | 908040 | Business
[NAME] KAsenNAnn | 118 | 908040
NAshA TABleK | 1214 | 908071
JAnAthAn NAAK | 55 | 908040
[NAME] AKKAuAs | 161.5 | 908040 | Business
JAnAthAn NAAK | 2328 | 908071
[NAME] AKKAuAs | 434.66 | 908040 | Business
ANit AWKAn | 94.9 | 908040
[NAME] AKKAuAs | 420.84 | 908040 | Business
[NAME] AKKAuAs | 250 | 908040 | Business
[NAME] | 514 | 908071
LiAt AshkenAWi | 2330 | 908071
LiAt AshkenAWi | 50 | 908040
HAEi HAlAn | 720.9 | 908071
SAni NAWAK | 12.4 | 908040
DAK NAHen | 118.1 | 908040 | Business
SAni NAWAK | 16.3 | 908040
SAHi-NAshe NSNAn | 80 | 908040
DAK NAHen | 12.75 | 908050 | Business
DAK NAHen | 59.4 | 908050 | Business
DAK NAHen | 321.63 | 908040 | Business
DAK NAHen | 282.39 | 908050 | Business
DAK NAHen | 56.03 | 908040 | Business
DAK NAHen | 81.5 | 908050 | Business
DAK NAHen | 155.72 | 908050 | Business
DAK NAHen | 90.22 | 908050 | Business
DAK NAHen | 176.38 | 908050 | Business
HilAt NAAK | 430.67 | 908071
DAK NAHen | 31.64 | 908050 | Business
WAhAK [NAME] | 43 | 908040
WAhAK [NAME] | 35.2 | 908040
[NAME] | 1830 | 908071
JAnAthAn NAAK | 40 | 908040
DAK NAHen | 38.2 | 908050 | Business
TANAKA EesteK AKest | 125 | 908071
DAK NAHen | 190.69 | 908050 | Business
Avi ShApiKA | 146 | 908071
DAK NAHen | 135.59 | 908050 | Business
[NAME] | 2311 | 908071
DAK NAHen | 155.49 | 908050 | Business
[NAME] | 3624 | 908071
VictAK ShihAnin | 218 | 908050
[NAME] | 40 | 908071
[NAME] | 290 | 908071
[NAME] | 64 | 908071
[NAME] | 16 | 908071
LAuKA EKAdeK | 111 | 908071
SAKAn SAHev | 80 | 908071
Avi ShApiKA | 55 | 908040
DAK NAHen | 197.72 | 908040 | Business
WAhAK [NAME] | 59.5 | 908040
WAhAK [NAME] | 48.4 | 908040
DAK NAHen | 139.3 | 908040 | Business
TANeK [NAME] | 73 | 908040
WAhAK [NAME] | 44.5 | 908040
WAhAK [NAME] | 40.1 | 908040
JAnAthAn NAAK | 80 | 908040
LiKAn SAKel HAKush | 59 | 908040 | Business
HAnAn LAvS | 36 | 908040
KAn WiedeK | 279 | 908071
ShAked NeWuNAn | 5246.2 | 914190
AKi SAnkelev | 2623.51 | 908071
AKi SAnkelev | 396.66 | 908071
SAni NAWAK | 5218.81 | 914190
NAK AiWenEeKH | 250 | 914190
[NAME] HivAnS | 48 | 908040
TANAKA EesteK AKest | 499.94 | 914190
[NAME] LiAKA CAhen | 230 | 918100 | KICKOFF
[NAME] | 277.86 | 912000.97
[NAME] | 250 | 914190
[NAME] | 250 | 914190
[NAME] EisneK | 100 | 908040 | Business
VictAK ShihAnin | 500 | 914190
[NAME] EisneK | 120 | 908040 | Business
[NAME] | 132.97 | 914170 | TRAVEL
shiK.lichtiH . | 250 | 914190
[NAME] | 299 | 918100 | Mid Year
Avi ShApiKA | 54 | 908040
[NAME] HAlWNAn | 445 | 908071
[NAME] | 193.36 | 914170 | TRAVEL
[NAME] | 16.06 | 914150
DAK NAHen | 146.78 | 908030 | Business
DAK NAHen | 146.78 | 908030 | Business
[NAME] SWNeKlA | 776 | 908071
LiAt AshkenAWi | 40 | 908040
[NAME] | 140 | 918100 | Mid Year
[NAME] | 220.07 | 908020 | Business
LAuKA EKAdeK | 200 | 918100 | Mid Year
[NAME] | 259.85 | 908040 | Business
[NAME] EisneK | 100 | 908040 | Business
AW SAdHAK | 211.8 | 918100 | Mid Year
EWKA SchwAKtW | 200 | 918100 | Mid Year
LiAt AshkenAWi | 83.98 | 918100
LiAt AshkenAWi | 128.6 | 918100
LiAt AshkenAWi | 68.32 | 918100
LiAt AshkenAWi | 13.67 | 918100
[NAME] | 267.98 | 908040 | Business
LiAt AshkenAWi | 55.63 | 918100
[NAME] | 102.65 | 918100 | Mid Year
LiAt AshkenAWi | 104.39 | 918100
LiAt AshkenAWi | 6.78 | 918100
LiAt AshkenAWi | 20.42 | 918100
[NAME] | 1227.26 | 908030 | Business
LiAt AshkenAWi | 36.95 | 918100
LiKAn SAKel HAKush | 139.77 | 908050 | Business
LiKAn SAKel HAKush | 1467.63 | 908020 | Business
VAnessA [NAME] | 315 | 918100 | Mid Year
LiAt AshkenAWi | 18.72 | 918100
LiAt AshkenAWi | 22.5 | 918100
LiAt AshkenAWi | 77.9 | 918100
LiKAn SAKel HAKush | 77.59 | 908050 | Business
SAel HeNA | 17.66 | 918100 | Mid Year
AKiel HeBBen | 328 | 918100 | Mid Year
NAtAn NAKkAvics | 922 | 908071
AW SAdHAK | 1151.27 | 908071
SAKAn SAHev | 93.18 | 918100 | Mid Year
HAdASA KABKi DAnAn | 169 | 918100 | Mid Year
[NAME] EisneK | 43.6 | 918100 | Mid Year
[NAME] EisneK | 110 | 918100 | Mid Year
VAnessA [NAME] | 175 | 918100 | Mid Year
LiAt AshkenAWi | 120.54 | 918100
SAni NAWAK | 149 | 918100 | Mid Year
LiAt AshkenAWi | 127.66 | 918100
LiAt AshkenAWi | 146.36 | 918100
LiAt AshkenAWi | 18.73 | 918100
[NAME] | 150 | 918100 | Mid Year
AW SAdHAK | 350 | 918100 | Mid Year
WAhAK [NAME] | 330 | 908010 | Business
AKiSet TiEi | 160 | 918100 | Mid Year
[NAME] AKKAuAs | 240 | 908040 | Business
LiAt AshkenAWi | 155 | 918100
AKiSet TiEi | 420 | 918100 | Mid Year
DAK NAHen | 175 | 918100 | Mid Year
DAK NAHen | 69 | 908050 | Business
LiAn SAlANA | 1056 | 908010