Page 1 of 1

ICETOLL Report : SUM of Amounts in OCCUR

PostPosted: Wed Jan 30, 2019 7:52 pm
by golemis
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

Re: ICETOLL Report : SUM of Amounts in OCCUR

PostPosted: Thu Jan 31, 2019 2:40 pm
by golemis
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))))

Re: ICETOLL Report : SUM of Amounts in OCCUR

PostPosted: Tue Oct 06, 2020 7:34 am
by vikbali
Is it still possible to get COUNT and SUM together using ICETOOL?

Re: ICETOLL Report : SUM of Amounts in OCCUR

PostPosted: Tue Oct 06, 2020 3:03 pm
by NicC
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?