View previous topic :: View next topic
|
Author |
Message |
janmejay Warnings : 1 New User
Joined: 22 Jun 2007 Posts: 85 Location: bangalore
|
|
|
|
Hi , by using icetool method i have generated the report , but i need to find out average of a partuculr field , like salary. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
Back to top |
|
|
janmejay Warnings : 1 New User
Joined: 22 Jun 2007 Posts: 85 Location: bangalore
|
|
|
|
By using average('text') , it displaying only the text. not showing average value of salary field. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
AVERAGE('text') will display the average for every numeric ON field. I suspect you're using CH as the format for the salary field instead of ZD. Change
ON(p,m,CH)
for the salary field to
ON(p,m,ZD)
where p is the starting position and m is the length, and you'll get the averge for that field. If you need help editing the ZD field to look a certain way, tell me the length of the ZD field and what you want it to look like in the report.
Remember when I said the following in my previous post:
Quote: |
If that's not what you want, then give more details - show the ICETOOL statements you're using and an example of your input records and what you want for output. |
If you had done what I asked, I wouldn't have to guess at what you have/want and we could be done by now. |
|
Back to top |
|
|
|