Decisions by Day Chart and Decision Date Field
We don't want a summary table. We want a visible chart. We are trying to create a chart "Decisions by Day" to see how many loans each day our loan officers are decisioning. There are four "decision" fields - Approved Date, Denied Date, Suspended Date, and Approved With Conditions Date.
We want the chart to show how many loans we are decisioning each day. I tried creating a field called "Decision Date" with If statements but it's not working.
In theory we were going to make it where if Approved Date = null, use Denied Date, if Denied Date is null, use Suspended Date, etc etc.
The Decision Date field would display any one of those 4 dates. How can we accomplish this? Thank you in advance!
------------------------------
Angelo Guariglia
------------------------------
We want the chart to show how many loans we are decisioning each day. I tried creating a field called "Decision Date" with If statements but it's not working.
In theory we were going to make it where if Approved Date = null, use Denied Date, if Denied Date is null, use Suspended Date, etc etc.
The Decision Date field would display any one of those 4 dates. How can we accomplish this? Thank you in advance!
------------------------------
Angelo Guariglia
------------------------------
