Hi,
I am measuring production, and I need to count the number of dinstinct clients (many appeals) that were completed timely & untimely.
Timely is equal to the following:
IIF ({DISPOSITION.DISPOSITIONENTRY_DATE}-{APPEAL.REQUEST_DATE} <= 30, "Timely", "Untimely")
OR
({DISPOSITION.DISPOSITIONENTRY_DATE}-{APPEAL.REQUEST_DATE} <= 90) AND
{APPEAL.PEPPERS_DELAY} = Not null OR
{HEARINGAPPEAL.HEARING_TYPE} ="R" then
"Timely"
Else "Untimely"
I need to account for both of the above situations, but I have not been able to make both of them work. Plus, I am not sure if I am trying to make it happen in the right way. Currently, I am trying to use the above in a formula.
Pretty Please & Thanks in advance for any suggestions that you may have for me.