Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with Application Data. Each application may or may not have one or many tracking records associated with the application number. If the tracking record exists, it will have a value for all of the fields in the tracking record table; if the Application has no tracking record(s), all tracking record fields will be null. How do I use set analysis to both count number of apps with a null tracking record as well as count and sum the apps with the tracking record? See Sample Data (Application # is the only field that comes from the Application Table)
Application # | TR Created Date | TR Locator | TR Refi Status | TR Refi Status User | TR Credit Lender | TR Credit Loan Type | TR Credit Curr. Balance | TR Refi Credit Limit | TR Refi. Int. Rate | TR Refi. Savings |
---|---|---|---|---|---|---|---|---|---|---|
14895 | - | - | - | - | - | - | - | - | - | |
584789 | 10/17/2014 | 305 | New Offer | Joe Smith | Chase Bank | Mortgage | 258,412 | 275,000 | 4.59 | 520.00 |
54125 | 10/24/2014 | 135 | Accepted | Kari Williams | AMEX | Credit Card | 7,568.00 | 10,000 | 2.99 | 87.00 |
42589 | 10/30/2014 | 206 | No Savings | Carl Fitz | Red Rocks CU | LOC | 500 | 500 | 7.59 | 0.00 |
658 | - | - | - | - | - | - | - | - | - | - |
25984 | 10/16/2014 | 584 | New Offer | Joe Smith | US Bank | Credit Card | 2698. | 5000.00 | 8.99 | 29.00 |
3652 | 10/2/2014 | 102 | New Offer | Susan George | Wells Fargo | Credit Card | 1595.00 | 2500.00 | 8.99 | 45.00 |
8549 | - | - | - | - | - | - | - | - | - | - |
15987 | 10/5/2014 | 103 | Ask Later | Kari Williams | Bellco CU | LOC | 2693.00 | 5000.00 | 7.59 | 94.00 |
15987 | 10/5/2014 | 104 | Ask Later | Kari Williams | Bellco CU | HELOC | 45,627.00 | 60,000 | 4.19 | 138.00 |
15987 | 10/5/2014 | 105 | Ask Later | Kari Williams | GM | Auto | 19,545.00 | 20,000.00 | 1.95 | 32.00 |
68741 | - | - | - | - | - | - | - | - | - | - |
Hi,
May be like this.
Have a look at attached application.
Regards
ASHFAQ
Please find .qvw with examples of If-statement as well as set analysis solution attached.