I am having serious difficulties in trying to do a percentage of Resolved Cases. My report pulls all cases within a specified date range.
So far I did the following.
Created the following formula - //Resolved
Then I created a 'Sum' Summary of the formula.
I tried to create a running total as follows
field to Summarize - Table.Incident Number
Evaluate - - x-2 - use a formula
I've several suggestions, none seem to have worked.
What should be my next task, assuming the Running total is ok.
So far I did the following.
Created the following formula - //Resolved
Code:
If {HPD_Help_Desk.Status} in ["Resolved", "Closed"]
Then
1
Then I created a 'Sum' Summary of the formula.
I tried to create a running total as follows
field to Summarize - Table.Incident Number
Evaluate - - x-2 - use a formula
Code:
{@Resolved} <> 0
I've several suggestions, none seem to have worked.
What should be my next task, assuming the Running total is ok.