topic Re: Using Average with char fields in Application Development and Automation Discussions

Using Average with char fields

Former Member — Fri, 06 Apr 2012 15:30:13 GMT

Greetings,

I created a report and I want to get the average for some database fields .

The type of these fields is char .How can I get the average?

Thanks and regards,

Noor Asd

Former Member — Fri, 06 Apr 2012 17:14:36 GMT

Hi,

Well, one way would be to leave the aggregate function on your SELECT statement and calculate the average value yourself within a loop...

Cheers,

Manu.

Former Member — Fri, 06 Apr 2012 20:12:14 GMT

since average is based on a numerical value, you're not doing to do it with char fields.

Former Member — Sun, 08 Apr 2012 07:21:50 GMT

Hi,

You have to move the values into a numerical variable before trying to average it.

Regards,

Karl