Spreadsheet: 797686d1664051855-round-calculated-field-in-pivot-table-doesnt-give-precise-sum-totals-test
Sheet: Sep

 |  |  | Values
CARDHOLDER | [NAME] | CUSTOM_FIELD_LABEL - customField1 - Reason for Travel | Sum of BILLABLE_ENTITY_AMOUNT | Sum of Field1 |  |  | Amount DB | Amount CR
AKi SAnkelev | 608071 | (blank) | 3020.17 | 3020 |  |  |  | 0
AKi SAnkelev Total |  |  | 3020.17 | 3020 |  |  | 0 | 3020
AKiel HeBBen | 618100 | Mid Year | 328 | 328 |  |  | 328 | 0
AKiel HeBBen Total |  |  | 328 | 328 |  |  | 0 | 328
AKiSet TiEi | 618100 | Mid Year | 580 | 580 |  |  | 580 | 0
AKiSet TiEi Total |  |  | 580 | 580 |  |  | 0 | 580
[NAME] | 608071 | (blank) | 1830 | 1830 |  |  | 1830 | 0
 | 614170 | TRAVEL | 50 | 50 |  |  | 50 | 0
AlAn ABek Total |  |  | 1880 | 1880 |  |  | 0 | 1880
[NAME] | 608071 | (blank) | 120 | 120 |  |  | 120 | 0
[NAME] |  |  | 120 | 120 |  |  | 0 | 120
[NAME] HivAnS | 608040 | (blank) | 48 | 48 |  |  | 48 | 0
[NAME] HivAnS Total |  |  | 48 | 48 |  |  | 0 | 48
ANit AWKAn | 608040 | (blank) | 94.9 | 95 |  |  | 95 | 0
 | 608071 | (blank) | 452.8 | 453 |  |  | 453 | 0
 | 612000.97 | (blank) | 342.73 | 343 |  |  | 343 | 0
ANit AWKAn Total |  |  | 890.4300000000001 | 890 |  |  | 0 | 890
AssAB AlAni | 614150 | (blank) | 61.56 | 62 |  |  | 62 | 0
AssAB AlAni Total |  |  | 61.56 | 62 |  |  | 0 | 62
Avi ShApiKA | 608040 | (blank) | 109 | 109 |  |  | 109 | 0
 | 608071 | (blank) | 146 | 146 |  |  | 146 | 0
 | 614170 | (blank) | 40 | 40 |  |  | 40 | 0
Avi ShApiKA Total |  |  | 295 | 295 |  |  | 0 | 295
AW SAdHAK | 608071 | (blank) | 1151.27 | 1151 |  |  | 1151 | 0
 | 618100 | Mid Year | 561.8 | 562 |  |  | 562 | 0
AW SAdHAK Total |  |  | 1713.07 | 1713 |  |  | 0 | 1713
DAK NAHen | 608020 | Business | 149.92 | 150 |  |  | 150 | 0
 | 608030 | Business | 293.56 | 294 |  |  | 294 | 0
 | 608040 | Business | 1445.07 | 1445 |  |  | 1445 | 0
 | 608050 |  | 1565.97 | 1566 |  |  | 1566 | 0
 | 618100 | Mid Year | 175 | 175 |  |  | 175 | 0
DAK NAHen Total |  |  | 3629.52 | 3630 |  |  | 0 | 3630
[NAME] EisneK | 608040 | Business | 320 | 320 |  |  | 320 | 0
 | 608071 | (blank) | 1780 | 1780 |  |  | 1780 | 0
 | 618100 | Mid Year | 153.6 | 154 |  |  | 154 | 0
[NAME] EisneK Total |  |  | 2253.6 | 2254 |  |  | 0 | 2254
[NAME] | 608040 | (blank) | 100 | 100 |  |  | 100 | 0
 | 614150 | (blank) | 53.9 | 54 |  |  | 54 | 0
 | 614160 | (blank) | 250 | 250 |  |  | 250 | 0
[NAME] |  |  | 403.9 | 404 |  |  | 0 | 404
[NAME] HAlWNAn | 608071 | (blank) | 445 | 445 |  |  | 445 | 0
[NAME] HAlWNAn Total |  |  | 445 | 445 |  |  | 0 | 445
EWKA SchwAKtW | 618100 | Mid Year | 200 | 200 |  |  | 200 | 0
EWKA SchwAKtW Total |  |  | 200 | 200 |  |  | 0 | 200
HAdASA KABKi DAnAn | 608071 | (blank) | 284 | 284 |  |  | 284 | 0
 | 614170 | TRAVEL | 47.8 | 48 |  |  | 48 | 0
 | 618100 | Mid Year | 169 | 169 |  |  | 169 | 0
HAdASA KABKi DAnAn Total |  |  | 500.8 | 501 |  |  | 0 | 501
HAEi HAlAn | 608071 | (blank) | 720.9 | 721 |  |  | 721 | 0
HAEi HAlAn Total |  |  | 720.9 | 721 |  |  | 0 | 721
HAnAn LAvS | 608040 | (blank) | 36 | 36 |  |  | 36 | 0
HAnAn LAvS Total |  |  | 36 | 36 |  |  | 0 | 36
HilAd AEKAhAN | 608071 | (blank) | 539 | 539 |  |  | 539 | 0
HilAd AEKAhAN Total |  |  | 539 | 539 |  |  | 0 | 539
HilAt NAAK | 608071 | (blank) | 430.67 | 431 |  |  | 431 | 0
HilAt NAAK Total |  |  | 430.67 | 431 |  |  | 0 | 431
IHAK HAv | 614170 | (blank) | 71 | 71 |  |  | 71 | 0
 |  | TRAVEL | 40 | 40 |  |  | 40 | 0
IHAK HAv Total |  |  | 111 | 111 |  |  | 0 | 111
JAnAthAn NAAK | 608040 | (blank) | 175 | 175 |  |  | 175 | 0
 | 608071 | (blank) | 2328 | 2328 |  |  | 2328 | 0
JAnAthAn NAAK Total |  |  | 2503 | 2503 |  |  | 0 | 2503
KAi WiNAn | 608040 | (blank) | 180.9 | 181 |  |  | 181 | 0
KAi WiNAn Total |  |  | 180.9 | 181 |  |  | 0 | 181
KAn WiedeK | 608071 | (blank) | 279 | 279 |  |  | 279 | 0
KAn WiedeK Total |  |  | 279 | 279 |  |  | 0 | 279
[NAME] | 608071 | (blank) | 514 | 514 |  |  | 514 | 0
[NAME] Total |  |  | 514 | 514 |  |  | 0 | 514
[NAME] KAsenNAnn | 608040 | (blank) | 118 | 118 |  |  | 118 | 0
[NAME] |  |  | 118 | 118 |  |  | 0 | 118
[NAME] LiAKA CAhen | 618100 | KICKOFF | 230 | 230 |  |  | 230 | 0
KAni LiAKA CAhen Total |  |  | 230 | 230 |  |  | 0 | 230
[NAME] | 608020 | Business | 220.07 | 220 |  |  | 220 | 0
 | 608030 | Business | 1227.26 | 1227 |  |  | 1227 | 0
 | 608040 | Business | 527.83 | 528 |  |  | 528 | 0
 | 618100 | Mid Year | 691.65 | 692 |  |  | 692 | 0
[NAME] |  |  | 2666.81 | 2667 |  |  | 0 | 2667
LAuKA EKAdeK | 608071 | (blank) | 111 | 111 |  |  | 111 | 0
 | 618100 | Mid Year | 200 | 200 |  |  | 200 | 0
LAuKA EKAdeK Total |  |  | 311 | 311 |  |  | 0 | 311
LiAn SAlANA | 608010 | (blank) | 1056 | 1056 |  |  | 1056 | 0
LiAn SAlANA Total |  |  | 1056 | 1056 |  |  | 0 | 1056
LiAt AshkenAWi | 608040 | (blank) | 90 | 90 |  |  | 90 | 0
 | 608071 | (blank) | 2330 | 2330 |  |  | 2330 | 0
 | 618100 | (blank) | 1206.15 | 1206 |  |  | 1206 | 0
LiAt AshkenAWi Total |  |  | 3626.15 | 3626 |  |  | 0 | 3626
LiKAn SAKel HAKush | 608020 | Business | 1467.63 | 1468 |  |  | 1468 | 0
 | 608040 | Business | 59 | 59 |  |  | 59 | 0
 | 608050 |  | 217.36 | 217 |  |  | 217 | 0
LiKAn SAKel HAKush Total |  |  | 1743.99 | 1744 |  |  | 0 | 1744
[NAME] | 608040 | (blank) | 86.9 | 87 |  |  | 87 | 0
 | 614170 | TRAVEL | 326.33 | 326 |  |  | 326 | 0
NAA EEenstein Wiv Total |  |  | 413.23 | 413 |  |  | 0 | 413
NAAN AKAd | 608040 | Business | 403.3100000000001 | 403 |  |  | 403 | 0
 | 608050 |  | 811.4300000000001 | 811 |  |  | 811 | 0
NAAN AKAd Total |  |  | 1214.74 | 1215 |  |  | 0 | 1215
NAK AiWenEeKH | 608040 | (blank) | 100 | 100 |  |  | 100 | 0
 | 614160 | (blank) | 250 | 250 |  |  | 250 | 0
NAK AiWenEeKH Total |  |  | 350 | 350 |  |  | 0 | 350
NAKiAh AWulAS | 608071 | (blank) | 883 | 883 |  |  | 883 | 0
NAKiAh AWulAS Total |  |  | 883 | 883 |  |  | 0 | 883
NAshA TABleK | 608071 | (blank) | 1214 | 1214 |  |  | 1214 | 0
NAshA TABleK Total |  |  | 1214 | 1214 |  |  | 0 | 1214
[NAME] | 608071 | (blank) | 2311 | 2311 |  |  | 2311 | 0
 | 614160 | (blank) | 250 | 250 |  |  | 250 | 0
NAshe KeuEinABB Total |  |  | 2561 | 2561 |  |  | 0 | 2561
NAtAn NAKkAvics | 608071 | (blank) | 922 | 922 |  |  | 922 | 0
NAtAn NAKkAvics Total |  |  | 922 | 922 |  |  | 0 | 922
[NAME] AKKAuAs | 608040 | (blank) | 69 | 69 |  |  | 69 | 0
 |  | Business | 1507 | 1507 |  |  | 1507 | 0
NichAel AKKAuAs Total |  |  | 1576 | 1576 |  |  | 0 | 1576
SAel HeNA | 618100 | Mid Year | 17.66 | 18 |  |  | 18 | 0
SAel HeNA Total |  |  | 17.66 | 18 |  |  | 0 | 18
SAHi-NAshe NSNAn | 606180.02 | (blank) | 972 | 972 |  |  | 972 | 0
 | 608040 | (blank) | 80 | 80 |  |  | 80 | 0
SAHi-NAshe NSNAn Total |  |  | 1052 | 1052 |  |  | 0 | 1052
SAKAn SAHev | 608071 | (blank) | 80 | 80 |  |  | 80 | 0
 | 618100 | Mid Year | 93.18 | 93 |  |  | 93 | 0
SAKAn SAHev Total |  |  | 173.18 | 173 |  |  | 0 | 173
[NAME] SWNeKlA | 608071 | (blank) | 776 | 776 |  |  | 776 | 0
[NAME] SWNeKlA Total |  |  | 776 | 776 |  |  | 0 | 776
SAni NAWAK | 608010 | Business | 149 | 149 |  |  | 149 | 0
 | 608040 | (blank) | 28.7 | 29 |  |  | 29 | 0
 |  | Business | 1146.52 | 1147 |  |  | 1147 | 0
 | 608050 |  | 490.2 | 490 |  |  | 490 | 0
 | 614160 | (blank) | 5218.81 | 5219 |  |  | 5219 | 0
 | 618100 | Mid Year | 149 | 149 |  |  | 149 | 0
SAni NAWAK Total |  |  | 7182.23 | 7182 |  |  | 0 | 7182
[NAME] | 612000.97 | (blank) | 277.86 | 278 |  |  | 278 | 0
 | 614150 | (blank) | 16.06 | 16 |  |  | 16 | 0
SehudA Lewis Total |  |  | 293.92 | 294 |  |  | 0 | 294
[NAME] | 608071 | (blank) | 3914 | 3914 |  |  | 3914 | 0
[NAME] |  |  | 3914 | 3914 |  |  | 0 | 3914
ShAked NeWuNAn | 614160 | (blank) | 5246.2 | 5246 |  |  | 5246 | 0
ShAked NeWuNAn Total |  |  | 5246.2 | 5246 |  |  | 0 | 5246
shiK.lichtiH . | 608040 | (blank) | 40 | 40 |  |  | 40 | 0
 | 614160 | (blank) | 250 | 250 |  |  | 250 | 0
shiK.lichtiH . Total |  |  | 290 | 290 |  |  | 0 | 290
SuvAl NAshiAch | 608010 | Business | 169 | 169 |  |  | 169 | 0
 | 608040 | Business | 517.23 | 517 |  |  | 517 | 0
 | 608050 |  | 1713.05 | 1713 |  |  | 1713 | 0
SuvAl NAshiAch Total |  |  | 2399.28 | 2399 |  |  | 0 | 2399
TANAKA EesteK AKest | 608071 | (blank) | 125 | 125 |  |  | 125 | 0
 | 614160 | (blank) | 499.94 | 500 |  |  | 500 | 0
TANAKA EesteK AKest Total |  |  | 624.94 | 625 |  |  | 0 | 625
TANeK [NAME] | 608040 | (blank) | 73 | 73 |  |  | 73 | 0
TANeK [NAME] |  |  | 73 | 73 |  |  | 0 | 73
VAnessA [NAME] | 618100 | Mid Year | 490 | 490 |  |  | 490 | 0
VAnessA TkAch Total |  |  | 490 | 490 |  |  | 0 | 490
VictAK ShihAnin | 608050 |  | 218 | 218 |  |  | 218 | 0
 | 614160 | (blank) | 500 | 500 |  |  | 500 | 0
VictAK ShihAnin Total |  |  | 718 | 718 |  |  | 0 | 718
WAhAK [NAME] | 608010 | Business | 330 | 330 |  |  | 330 | 0
 | 608040 | (blank) | 311.1 | 311 |  |  | 311 | 0
WAhAK DAvid Total |  |  | 641.1 | 641 |  |  | 0 | 641
Grand Total |  |  | 64460.95 | 64461