Hi Gary,
To get the required information you may have to write 3 formulas :
formula1
Numbervar closed;
if TicketStatus = 'Closed"
Then
Closed:=Closed+1;
Closed;
formula2
Numbervar open;
if TicketStatus = 'Open"
Then
open:=open+1;
open;
formula3
Numbervar reassign;
if TicketStatus = 'Reassign"
Then
reassign:=reassign+1;
reassign;
Now place these formulas on your report details section and insert summaries to get the total count.
Thanks,
Sastry
Create 3 running totals like
#Closed: --add the summary field --select summary as count --use formula for evaluate and write the formula like TicketStatus = "Closed" #Open: --add the summary field --select summary as count --use formula for evaluate and write the formula like TicketStatus = "Open" #Reassign: --add the summary field --select summary as count --use formula for evaluate and write the formula like TicketStatus = "Reassign"
place these running totals in report footer
Regards,
Raghavendra
Add comment