Hi
I know we can use running totals to summarise and place results in the report footer, say I want to work out the number of waiting tickets like this:
IF {Incident.Status} = "Waiting" Then Count ({LastAssignment.ParentNumber})
If I wanted to add this to the page header it would come us as 0 records.
So, I create a running total called #Waiting like this:
Filed to summarize = Incident.Status
Type of Summary = Count
Evaluate using a formula which = Incident.Status = "Waiting"
I would then place this in the Rerport Footer and bingo I have my correct result!!
I can then add this in the report footer to work out the percentage
{#Waiting}/Count({LastAssignment.ParentNumber})*100 //percent of waiting
but how do we add a formula to enable us to insert the result anywhere on the report, like the header??? without using a running total??
Thanks