Spreadsheet: 57056d1257235909-how-to-solve-1-n-a-2-double-counting-when-comparisons-are-made-comparison
Sheet: Sheet1

NIIVAR | NIIVAR Amount | CB_Consol | CB_Consol Amount
OVERDRAFTS - CLEAN | 567 | UNSECURED LENDING OTHERS (01#02151) | 36.77815664156267
OVERDRAFTS - CASH BACKED | 0.1913311304536203 | CASH BACKED (01#0415_01) | 34.62172924066234
MORTGAGES | 0.7498226603759974 | MORTGAGE LOANS (Excl MOA) (01#0405_01) | 342.2437823252324
MORTGAGE OD | 0.1158946341547304 | MORTGAGE OVERDRAFT (01#00720) | 16.21339437147452
PERSONAL LOANS | 0.5522782293991648 | INSTALLMENT LOANS-RET (01#00095) | 1307.592020309668
OTHER LOANS - SECURED | 0.2922941252432025 | SECURED PERSONAL LOANS (01#0410_02) | 1.256148153322741
OTHER LOANS - UNSECURED | 0.2499603644128481 | UNSECURED LENDING OTHERS (01#02151) | 36.77815664156267
Prepaid Card | 0.885679481882828 | ?? | 0
CARDS | 0.1618848621784528 | CREDIT CARD-ACQUIRING (00010) | 0
CARDS | 0.4055278233808206 | CREDIT CARD-ISSUING (01#00005) | 2485.940742593119
AUTO LOANS | 0.7321384612658584 | AUTO LOANS (01#0410_01) | 0.02054593364936986
SME LOANS | 0.708401932692829 | UNSECURED LENDING OTHERS (03#02151) | 90.89671116953491
SME LOANS | 0.2785883410800472 | INSTALLMENT LOANS-RET (03#00095) | 117.3814322855322
SME LOANS | 0.5329511653787915 | PERSONAL OVERDRAFTS-RET (03#00600) | 1.642089751662271
SME LOANS | 0.08937700283239547 | MORTGAGE (03#0405) | 139.6039488847455
SME LOANS | 0.7843812837126674 | TERM LNS (03#0413_01) | 0
SME LOANS | 0.7895857008599851 | BFS OVERDRAFTS (03#00935) | 16.40142235591362
SME LOANS | 0.2000946348747012 | SME OTH SECURED LOANS (03#0415_03) | 0.457272224286393
SME LOANS | 0.6747950169399974 | OTHER AMS FEES (03#0505_04) | 0
SME LOANS | 0.6495120104114953 | FX_ (03#1005_02) | 0
SME LOANS | 0.07497579541514021 | IMPORT TRADE (03#0805_01) | 2.502984630145832
SME LOANS | 0.9622881082077983 | GUARANTEES TRADE_ (03#0805_08) | 0
READY CREDIT | 0.7097014285652936 | REVOLVING CREDITS (01#00700) | 0
SME DEPOSITS | 0.7636016715540321 | CURRENT ACCOUNTS-RET_ (03#0505_01) | 259.1989697246009 |  |  | 24
SME DEPOSITS | 0.9600767704832578 | SAVINGS ACCOUNTS-RET (03#00035) | 0.03983520193849185 |  |  | 1
SME DEPOSITS | 0.5876832890350148 | TIME DEPOSITS-RET_ (03#0505_03) | 30.11429479271928
NON INTEREST CURRENT ACCOUNT | 0.2181193024090358 | CURRENT ACCOUNTS-RET_ (01#0505_01) | 71.26064575295544
CURRENT ACCOUNT (Interest Bearing) | 0.3295182769048877 | CURRENT ACCOUNTS-RET_ (01#0505_01) | 71.26064575295544
CHEQUE AND SAVE | 0.6282516121029738 | CURRENT ACCOUNTS-RET_ (01#0505_01) | 71.26064575295544
SAVINGS ACCOUNTS | 0.03991266674121619 | SAVINGS ACCOUNTS-RET (01#00035) | 159.5372940671333
ACC INTEREST PAYABLE | 0.1572766181861669 | ?? | 0
BND FIXED DEPOSITS | 0.03674696671006217 | TIME DEPOSITS-RET_ (01#0505_03) | 162.4357662789198
PREPAID CARD | 0.03912274928435355 | ALM - CUSTOMER DEPOSITS (01#1005_05) | 0.02864971851623447
PCD | 0.7183436264142584 | PREMIUM CURRENCY INVESTMENTS (01#1005_06) | -15.97913345158912
ADHOC DEPOSITS | 0.1303507401702273 | TIME DEPOSITS-RET_ (01#0505_03) | 162.4357662789198
FOREIGN CURRENCY DEPOSITS | 0.3612308275604752 | TIME DEPOSITS-RET_ (01#0505_03) | 162.4357662789198
?? |  | OTHER DEFINED PRODUCTS (01#00585) | 0
?? |  | OTHER AMS FEES (01#0505_04) | 0
?? |  | TRANSACTIONAL FX (01#1005_01) | 0
?? |  | INSURANCE SERVICES (01#00540) | 0
?? |  | UNIT TRUSTS (01#00545) | 0
?? |  | STRUCTURED  NOTES (01#01305) | 0
?? |  | STRUCTURED DEPOSITS (01#1005_03) | 0
 |  |  | 5764.359683661019
 |  |  | -36.77815664156267
 |  |  | -162.4357662789198
 |  |  | -71.26064575295544
 |  |  | -71.26064575295544
 |  |  | -162.4357662789198
 |  |  | 5260.188702955706
 |  | Total CB [NAME] | 5260.188702955707