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.

(right click on Running Toal ans select New)

field to summarize=clientid

type=distinctcount

evaluate=usea  formula

({DISPOSITION.DISPOSITIONENTRY_DATE}-{APPEAL.REQUEST_DATE} <= 30)

 

 

It selects this part:

reset=never
place in report footer
 
same for untimely but evaluate formual is
NOT(({DISPOSITION.DISPOSITIONENTRY_DATE}-{APPEAL.REQUEST_DATE} <= 30)
or
(
({DISPOSITION.DISPOSITIONENTRY_DATE}-{APPEAL.REQUEST_DATE} <= 90) AND
((not isnull({APPEAL.PEPPERS_DELAY})) or
{HEARINGAPPEAL.HEARING_TYPE} ="R" )
))

 

({DISPOSITION.DISPOSITIONENTRY_DATE}-{APPEAL.REQUEST_DATE} <= 30)
or
(
({DISPOSITION.DISPOSITIONENTRY_DATE}-{APPEAL.REQUEST_DATE} <= 90) AND
((not isnull({APPEAL.PEPPERS_DELAY})) or
{HEARINGAPPEAL.HEARING_TYPE} ="R" )
)
reset=never
place in report footer
 
same for untimely but evaluate formual is
NOT(({DISPOSITION.DISPOSITIONENTRY_DATE}-{APPEAL.REQUEST_DATE} <= 30)
or
(
({DISPOSITION.DISPOSITIONENTRY_DATE}-{APPEAL.REQUEST_DATE} <= 90) AND
((not isnull({APPEAL.PEPPERS_DELAY})) or
{HEARINGAPPEAL.HEARING_TYPE} ="R" )
))