How to compute the percentage on TRAILER3 in Syncsort

Raghunadhareddy.J · New User Joined: 26 Apr 2011 Posts: 6 Location: INDIA

My report file is as follows.
I need to compute the percentage by diving the second value by first value and percentage should be placed after the second value.

TOTAL 7,441 12
TOTAL 416,744 5,972

Thanks & regards
Raghu

dbzTHEdinosauer · Posted: Thu Apr 28, 2011 4:53 pm

Raghunadhareddy.J · New User Joined: 26 Apr 2011 Posts: 6 Location: INDIA

we are using sync sort

Arun Raj · Posted: Fri Apr 29, 2011 1:56 pm

Does your input file have only TWO records always? And what is the expected output out of the sample input you have shown above?

Raghunadhareddy.J · New User Joined: 26 Apr 2011 Posts: 6 Location: INDIA

Hi Arun,

My input has many lines.not only two lines.
where ever we had a line having TOTAL in the report i need to compute the percentage and should be placed after the second value.

Thanks & regards
Raghu

Arun Raj · Posted: Fri Apr 29, 2011 9:31 pm

Why don't you show us a sample input and the expected output using "Code" tags.

Raghunadhareddy.J · New User Joined: 26 Apr 2011 Posts: 6 Location: INDIA

Hi Arun,

we can use SUM,MIN,MAX,AVG in TRAILER3 statement in sort.
As TRAILER3 statement does not allow arithmetic operations,created a module using the function NUMVAL-C that converts edited picture declaraions to normal declarations to compute percentage for the total lines on the report.
I am done with my requirement.
Thanks a lot for your time.

Thanks & Regards
Raghu

Arun Raj · Posted: Wed May 04, 2011 11:13 pm

It's good to hear that you've found a way out yourself. But without having any clue on your requirement, I can't just agree to the point that it's not doable with your sort product.