ICETOLL Report : SUM of Amounts in OCCUR



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

ICETOLL Report : SUM of Amounts in OCCUR

Postby 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:

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 :

    01/30/19 XXXX Failures Report - 1 -

    Fail/Success Count
    ------------ ---------------
    FALSE 114
    TRUE 3708

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

If I add:

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
golemis
 
Posts: 28
Joined: Wed Apr 04, 2018 8:13 pm
Location: London, UK
Has thanked: 7 times
Been thanked: 0 time

Re: ICETOLL Report : SUM of Amounts in OCCUR

 

Re: ICETOLL Report : SUM of Amounts in OCCUR

Postby golemis » Thu Jan 31, 2019 2:40 pm

Solved using:

 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))))
golemis
 
Posts: 28
Joined: Wed Apr 04, 2018 8:13 pm
Location: London, UK
Has thanked: 7 times
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post