Maximum and Minimum

[psamedy]

Hello All

I have a graph grouped by Name displaying the average score per Name for q1, q2, q3.

I need to display on the page the individuals higest avg score and lowest avg score? THanks for any help. Pat

Name q1 q2 q3
---- -- -- --
Bob 1 4 3
Bob 5 3 4
Jed 3 2 4
Tom 2 5 1

 

[lbass]

The following formula will give you the maximum:

whileprintingrecords;
numbervar max;

if Average ({table.scoreQ1}, {table.name}) >
Average ({table.scoreQ2}, {table.name}) then
max := Average ({table.scoreQ1}, {table.name}) else
max := Average ({table.scoreQ2}, {table.name});
if Average ({table.scoreQ3}, {table.name}) > max then
max := Average ({table.scoreQ3}, {table.name}) else
max := max;

For the minimum, try:

whileprintingrecords;
numbervar min;

if Average ({table.scoreQ1}, {table.name}) <
Average ({table.scoreQ2}, {table.name}) then
min := Average ({table.scoreQ1}, {table.name}) else
min := Average ({table.scoreQ2}, {table.name});
if Average ({table.scoreQ3}, {table.name}) < min then
min := Average ({table.scoreQ3}, {table.name}) else
min := min;

-LB