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