I think this is going to be grouping 1

[ddrafts]

Here are the three formulas that I'm using. I'm grouping by LogonClosed by. If I put a summary in for the Sev1< and the Sev1> it shows correctly for each user. I'm trying to get the % but when I add it in the Group Header it is the % for all.

The way they would want to see it is

user sev1< Sev1> %in compliance
Paul 8 0 100%
Sam 10 3 76.92%


Sev1<
If {@ClosedDiff} <= 1 and
(month({Incident.Open Date & Time})) = (month({Incident.Close Date & Time})) And
{Incident.Priority:} = "SEVERITY 1" Then 1

Sev1>
If {@ClosedDiff} > 1 and
(month({Incident.Open Date & Time})) = (month({Incident.Close Date & Time})) And
{Incident.Priority:} = "SEVERITY 1" Then 1

Sev1diff%
{@sev1<onedaysum}%({@sev1>onedaysum}+{@sev1<onedaysum})

Any help would be appreciated.
Thanks
Doug

 

[ddrafts]

Sorry it is CR 10

 

[lbass]

sum({@sev1<onedaysum},{table.user})%(sum({@sev1>onedaysum},{table.user})+sum({@sev1<onedaysum},{table.user}))

-LB

 

[ddrafts]

Thank you so much LBass. As I didn't know that the Big Boss was going to be in town today and wanted to see this report.