Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
Posted: Wed May 27, 2009 7:06 am Post subject:
maybe, your 'amounts' in 12 for 10 are not ZD.
define them differently in your SUM card.
Maybe UFF?
I don't know the answer but if you look in the manual... _________________ Dick Brenholtz
American living in Varel, Germany
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Wed May 27, 2009 10:09 am Post subject:
sivafdms,
The sort step has so many problems.
1. You Amounts fields are NOT ZD , they are UFF format. You canNOT use UFF format in SUM statement
2. You are merging on the key 6,2 and in the output you are writing 7,2, and the sum statement is summing 12,10 and you are writing 13,11? . Does that even make sense?
If you want sum amounts with embedded decimal point and spaces then search the forum for UFF (no sign) SFF (signed) _________________ Kolusu
www.linkedin.com/in/kolusu
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum