Averaging Data in an Array

[James1963]

I am using Crystal XI and I am am trying to average the array I have built in a main report and is passed to a subreport. I am spliting the data in the subreport to graph employee sick leave. I have tried to average the split data but no luck. I have tried a couple of loop formulas but no luck as well. Any ideas would be appreciated.

@ShowValue
if isnumeric(split({?Pm-@StrShowValue},"^")[groupnumber])
then tonumber(split({?Pm-@StrShowValue},"^")[groupnumber])
Works beaautifully but now I want to avearge these figures that are being graphed for a rolling twelve month average.
the data looks like this(0.89^1.77^2.25^2.77....)

James

 

[Madawc]

You could average them on the main report and pass that.

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