running total or summary field can't be created!

[wolverinec7]

i have a report thats grouped by engineer, then by the calls he's made. i'm trying to work out if he fixed the machine first time around. i have a disctinct count of a field which is different for every event attached to a call number. i cant then create a formula to say if = 1 then 1 else 0 but it wont let me sum the 1's up to work out a % against all his jobs

please help

 

[pgtek]

hi
try this
(Countcalls)/enginner)*100

pgtek

 

[lbass]

You can use variables. Create three formulas:

//{@reset} to be placed in the engineer group header:
whileprintingrecords;
numbervar sumdcnt := 0;

//{@accum} to be placed in the Calls group header or footer:
whileprintingrecords;
numbervar sumdcnt := sumdcnt + {@yourdistinctcountformula};

//{@display} to be placed in the Engineer group footer:
whileprintingrecords;
numbervar sumdcnt;

-LB

 

[wolverinec7]

LB thanks that works almost perfectly but where its creating a running total for everything, i only want it to sum up if the engineer fixed it at the first time of asking, i.e. when the distinct count is = 1 and ignore anything else

cheers

 

[wolverinec7]

and how come when i try to work out a percentage it bring sup 1 for every engineer?

display/distinctcount call number = 1 ??

cheers

 

[wolverinec7]

no idea how but the same formula now works out a percentage and i pointed your accum formula towards another one and it all works perfectly

thanks again LB