Crystal Reports XI - the MEan function

[Anushkas]

Hi there,

Does CR XI have the Mean function. If it is not available, can someone help me on how to do that calc.. the data after calculating the age at referral is this.. can anyone tell me how to get the Mean. I am not a statistics avay person. thks in advance

is
# of clients: 71
Minimun 12 Median 44 Maximum:162

Usha Meister

 

[Madawc]

Totals include a range of options, including mode, median and 'average', which I assume is the same as 'mean'.

Right-click on a field and choose Insert to get a choice of Running Total or Summary. Or else use the Field Explorer, the icon that is a grid-like box, to add running totals.

Running totals allow you to do clever things with grouping and formulas. They also accumulate for each line, hence the name. The disadvantage is that they are working out at the same time as the Crystal report formats the line. You cannot test for their values until after the details have been printed. You can show them in the group footer but not the group header, where they will be zero if you are resetting them for each group.

Summary totals are cruder, but are based directly on the data. This means that they can be shown in the header. They can also be used to sort groups, or to suppress them. Suppress a group if it has less than three members, say. They default to 'Grand Total', but also can be for a group.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Mean is the same as average, so you can right click on the field you want to summarize and insert summary->average. If you have row inflation, you could group on your field and then use a running total where you select the average of your field, evaluate on change of group (your field).

-LB