IBM Mainframe Forum

by **golemis** » Wed Jan 30, 2019 7:52 pm

Hi,
I have a Dataset which have two distinct values on pos 221-225. They also have Amounts in pos 205-215. I need to build a summary report for count and sum of the two occurrences. I try:

Select all

OCCUR  FROM(SORTIN) LIST(PRT) BLANK -
DATE TITLE('XXXX Failures Report') PAGE -
    HEADER('Fail/Success') HEADER('Count') -
    ON(221,5,CH) ON(VALCNT)

Which gives me :

but I cannot find a way to include the total amount of the two above cases next to the count.

If I add:

Select all

DISPLAY FROM(SORTIN) LIST(PRT) BLANK -
  HEADER('Amount') ON(205,11,SFF) -
  BTITLE('F/S') BREAK(221,5,CH) -
    BTOTAL('Total')

I get almost all records listed and I am getting into a mess

Any hints ?

Thanks in advance, George

by **golemis** » Thu Jan 31, 2019 2:40 pm

Solved using:

Select all

  SORT FIELDS=(221,5,CH,A)
    OUTFIL REMOVECC,NODETAIL,
    SECTIONS=(221,5,
    TRAILER3=(221,5,10:COUNT,
    20:TOT=(205,11,UFF,EDIT=(IIIIIIIT.TT))))

by **vikbali** » Tue Oct 06, 2020 7:34 am

Is it still possible to get COUNT and SUM together using ICETOOL?

by **NicC** » Tue Oct 06, 2020 3:03 pm

Why do you not read the manual for your sort version and run some experiments instead of tagging on to the end of someone elses old topic?

IBM Mainframe Forum

ICETOLL Report : SUM of Amounts in OCCUR

ICETOLL Report : SUM of Amounts in OCCUR

Re: ICETOLL Report : SUM of Amounts in OCCUR

Re: ICETOLL Report : SUM of Amounts in OCCUR

Re: ICETOLL Report : SUM of Amounts in OCCUR