ICETOLL Report : SUM of Amounts in OCCUR

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

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

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:

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

[golemis]

Solved using:

Code: 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))))

[vikbali]

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

[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?