Count Formula Issue.xlsx |
---|
|
---|
| A | B | C | D | E | F | G | H | I | J | K | L |
---|
1 | Legal Entity | (Multiple Items) | | | | | | | | | | |
---|
2 | Line of Business | (All) | | | | | | | | | | |
---|
3 | Counterparty Line of Business | (All) | | | | | | | | | | |
---|
4 | Reporting Classification | >= 1M AND <10M | | | | | | | | | | |
---|
5 | | | | | | | | | | | | |
---|
6 | Sum of Actual YTD | | | | | | | | Total Sum | Total Count | | |
---|
7 | Account Classification | FinancialStatement_IG | Join LOB | Tag | Tag Actual Balance YTD | Total | | | Balance Sheet _>= 1M AND <10M | Balance Sheet _>= 1M AND <10M | Expected Result | |
---|
8 | Balance Sheet | Balance Sheet _>= 1M AND <10M | NZ BankingNZ Banking | 4301. - 582 vs588 entity | 1,283,575 | 1,283,575 | | Specialist Businesses | - 7,718,151 | 4 | 4 | TRUE |
---|
9 | | Balance Sheet _>= 1M AND <10M | Specialist BusinessesWIB | 278. - Ent 671 Bank (WBC) | - 7,444,953 | 15,471,831 | | Business Bank | - | 1 | 0 | FALSE |
---|
10 | | Balance Sheet _>= 1M AND <10M | Specialist BusinessesWIB | 3488. - SGML Bank account - (SGB) | 5,630,963 | 27,641,552 | | Consolidation | - | 1 | 0 | FALSE |
---|
11 | | Balance Sheet _>= 1M AND <10M | Specialist BusinessesWIB | 3618. - AUD Nostro/Vostro between Pacific Banking and WBC Sydney | - 3,046,616 | 8,002,196 | | Consumer Bank | - | 1 | 0 | FALSE |
---|
12 | | Balance Sheet _>= 1M AND <10M | Specialist BusinessesWIB | 374. - WLIS Cash balances | - 2,857,545 | 17,406,212 | | Group Business Unit | - | 1 | 0 | FALSE |
---|
13 | | Balance Sheet _>= 1M AND <10M | Treasury & Structured FinanceWIB | 3281. - Offshore Nostro accounts held by NY | - 6,656,414 | 613,292 | | Chief Operating Office | - | 1 | 0 | FALSE |
---|
14 | | Balance Sheet _>= 1M AND <10M | WIBNZ Banking | 25. - Nostro/Vostro between NZ Wellington (Vostro) and WBC Sydney (Nostro). Variance relates to timing difference. | - 1,492,257 | 40,618,625 | | Treasury & Structured Finance | - 6,656,414 | 1 | 1 | TRUE |
---|
15 | | Balance Sheet _>= 1M AND <10M | WIBNZ Banking | 3940. - Calypso v Midas NZD B/S | 8,376,175 | 50,258,196 | | WIB | - 7,490,646 | 7 | 7 | TRUE |
---|
16 | | Balance Sheet _>= 1M AND <10M | WIBSpecialist Businesses | 278. - Ent 671 Bank (WBC) | - 7,444,953 | - 22,916,784 | | NZ Banking | 8,167,494 | 3 | 3 | TRUE |
---|
17 | | Balance Sheet _>= 1M AND <10M | WIBSpecialist Businesses | 3488. - SGML Bank account - (SGB) | 5,630,963 | - 22,010,589 | | | | | | |
---|
18 | | Balance Sheet _>= 1M AND <10M | WIBSpecialist Businesses | 3618. - AUD Nostro/Vostro between Pacific Banking and WBC Sydney | - 3,046,616 | - 11,048,812 | | | | | | |
---|
19 | | Balance Sheet _>= 1M AND <10M | WIBSpecialist Businesses | 374. - WLIS Cash balances | - 2,857,545 | - 20,263,757 | | =COUNT(UNIQUE(FILTER(D$8:D$1000,(B$8:B$1000=$J$7)*ISNUMBER(SEARCH(H8,C$8:C$1000)),0))) | | | | |
---|
20 | | Balance Sheet _>= 1M AND <10M | WIBTreasury & Structured Finance | 3281. - Offshore Nostro accounts held by NY | - 6,656,414 | - 7,269,706 | | =ROWS(UNIQUE(FILTER(D$8:D$1000,(B$8:B$1000=$J$7)*ISNUMBER(SEARCH(H8,C$8:C$1000)),0))) | | | | |
---|
21 | | Balance Sheet _>= 1M AND <10M | WIBWIB | 25. - Nostro/Vostro between NZ Wellington (Vostro) and WBC Sydney (Nostro). Variance relates to timing difference. | - 1,492,257 | - 42,110,882 | | | | | | |
---|
22 | | Balance Sheet _>= 1M AND <10M | WIBWIB | 3940. - Calypso v Midas NZD B/S | 8,376,175 | - 41,882,021 | | | | | | |
---|
23 | Profit and Loss | Profit and Loss_>= 1M AND <10M | NZ BankingNZ Banking | 467. - NZ Incorporations | - 1,318,679 | - 1,318,679 | | | | | | |
---|
24 | | Profit and Loss_>= 1M AND <10M | WIBWIB | 4711. - SYD and WLG translation diffs 213017 vs 205097 | 1,898,075 | 1,898,075 | | | | | | |
---|
25 | Grand Total | | | | | - 5,627,675 | | | | | | |
---|
|
---|