
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WAS IS Analysis
Dear All,
My apologies i was inquiring for WAS-IS analysis.
What i want to do is to do comparison of statuses From Previous month with current month and count records.
Loans Was-Is Analysis/Report - Aug 17 & Sep 17 | |||||||||
Details | Number of Loans | ||||||||
Bukt 1 | Bukt 2 | Bukt 3 | Bukt 4 | Bukt 5 | Bukt 6 | Bukt 7 | Total | ||
Resolved | 12 | 1 | 2 | 0 | 1 | 0 | 1 | 17 | |
Moved Back | 0 | 5 | 2 | 1 | 0 | 0 | 0 | 8 | |
Retained | 14 | 5 | 4 | 1 | 1 | 0 | 0 | 25 | |
Moved Forward | 13 | 9 | 14 | 13 | 13 | 10 | 408 | 480 | |
Total in # | 39 | 20 | 22 | 15 | 15 | 10 | 409 | 530 |
1. "Details" are calculated dimensions based on the movement of record in previous month when compared against Current month | |
2. "Buckets 1-7" will have movement of records in Previous month as compared to Current month. |
Regards,
Saad
Message was edited by: saad zaman

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you be more specific?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My apologies, i have now edited my post.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I am not sure if i am following what you mean?
Does the table show change in the number in number of loans month on month?
so First line for Resolved you have 12 in bucket 1, The 1 bucket 2 because there have been a change of one in the number loans.
If so you can look at peek previous functions to approach in Script.
or in table look at the before() Function.
Mark

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI Mark,
What I will do is I will be looking for the records from the previous month in any of the mentioned buckets in the current month and then i will count number of records.
Viz: If the ID for a particular record was in the previous month but not in any of the buckets in current month then it will be classified as Resolved. If the record was in Bucket 1 in previous month and has moved to any of the buckets between bucket 2- 7 then it will be classified as Moved Forward, If the record was in bucket 7 in the previous month and in the current month moved to any of the buckets between Bucket 2-6 then it will be classified as Moved Backward, if there is no change in the bucket from previous to the current month then classified as "Retained".
Kindly advise how to get this in the form of above table.
Regards,
Saad Zaman
