When using SUM FIELDS=(none) OR (Some field from the layout),
the duplicate records will get eliminated. Which record will get eliminated the first record or the second record found (as both are same ). I tried testing and found both the scenario happening. If i want to retain the first record and eliminate the second what exactly to be done.
When used in conjunction with SUM, EQUALS indicates which of the equal-keyed records will be preserved, containing the sum: the record occurring first in SORTIN (for a sort), or drawn from the SORTINnn data set with the lowest nn number (for a merge) will contain the totaled fields.