field cannot be summarized

[reacha]

In the report first i have group by supervisor_name
and then group by agentid

There are 2 formulas which are

QA_score:

if isnull(Sum ({Command.TOTAL_POINTS}, {Command.AGENT_ID(1)})) then 0 else
Sum ({Command.TOTAL_POINTS}, {Command.AGENT_ID(1)})

goal:
if isnull(Sum ({Command.TOTAL_POINTS}, {Command.AGENT_ID(1)})) then 0
else if Sum ({Command.TOTAL_POINTS}, {Command.AGENT_ID(1)}) >88 then 1

Then i want to count how many of goals are 1
like count(goal,supervisor_name)

i am getting an error like goal cannot be summarized and there is no summary option coming up

Please help me out

Thanks,
reacha

 

[kray4660]

You cannot summerize a summary. I am not sure (without knowing the DB) if there is a workaround.

 

[reacha]

Is there any other way to do this.










Thanks,
reacha

 

[lbass]

Use variables by creating these formulas:

//{@accum} to be placed in the agentID group header or footer section:
whileprintingrecords;
numbervar sumpts := sumpts + {@QA_score};
numbervar sumgr88 := sumgr88 + {@goal};

//{@reset} to be placed in the supervisor group header:
whileprintingrecords;
numbervar sumpts;
numbervar sumgr88;
if not inrepeatedgroupheader then (
sumpts := 0;
sumgr88 := 0
);

//{@displaysumpts} for the supervisor group footer:
whileprintingrecords;
numbervar sumpts;

//{@displaysumgr88} for the supervisor group footer:
whileprintingrecords;
numbervar sumgr88;

-LB

 

[reacha]

It did not work for me lboss thank you for help


Agentid QA Score @goal
John
14084 83 0
15879 88 1
11111 95 1
- --------------------------------
2
----------------------------------


Please help me out

Thanks,
reacha

 

[lbass]

Please review the placement of the formulas. You should suppress {@accum}.

I only see one display formula and it is correct.

If something still doesn't work, please explain how.

-LB

 

[reacha]

@aacum i have placed in the agentid group header section and supressed it
and reset in supervisor_name header section and
{@displaysumgr88} for supervisor header section.

But the counts i am not getting correct

Agentname agentid QA_score Goal

John
Jonathan Ramos 13001 0 0
Michael Pokas 13006 85 0
Rodney Pineda 13007 90 1
Edgar Falcon 13014 105 1
Duane Pilat 13018 56 0
John Jonse 13031 65 0







Thanks,
reacha

 

[lbass]

The TWO separate display formulas belong in the supervisor group FOOTER.

-LB

 

[reacha]

Thank you so much It worked for me











Thanks,
reacha

 

[reacha]

Now i want to divide that

if DistinctCount ({Command.AGENT_LNAME}, {Command.SUPERVISOR_NAME}) <> 0
then {@displaysumgr88}%DistinctCount ({Command.AGENT_LNAME}, {Command.SUPERVISOR_NAME})

and place this in the supervisor header section.

I am getting wrong values if i do this


Thanks,
reacha

 

[reacha]

Thank you so much issue resolved




Thanks,
Reacha

 

[lbass]

How did you resolve it? You can't reference the variable in the group header and still get an accurate result. Your formula would only be correct in the group footer.

-LB

 

[reacha]

Its not resolved but i asked my lead it can be done in this way only but not the other.


If there is any other way to display in the header please help me out





Thanks,
reacha