| Author |
Message |
janmejay
New User
Joined: 22 Jun 2007
Posts: 8
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 |
|
 |
References
|
 Posted: Tue May 06, 2008 3:31 pm Post subject: Re: use average command in icetool report generation method |
|
|
|
|
| Moved: Tue May 06, 2008 4:07 pm by superk From SMS & VSAM to DFSORT/ICETOOL |
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 3804
Location: San Jose, CA
|
|
| Back to top |
|
|
janmejay
New User
Joined: 22 Jun 2007
Posts: 8
Location: bangalore
|
|
|
|
| By using average('text') , it displaying only the text. not showing average value of salary field. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 3804
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 |
|
|
|
|
