topic summing like fields in a table in Application Development and Automation Discussions

summing like fields in a table

Former Member — Tue, 11 Sep 2007 18:31:26 GMT

I have an interanl talbe which I want summarize data by 2 fields. !st by confirmation number then by reason code. I trid using AT NEW but it would not allow me to use 2 fields.

Re: summing like fields in a table

Former Member — Tue, 11 Sep 2007 18:37:07 GMT

Use AT NEW with the second field of the internal table only. It will also break at the first field.

Rob

Re: summing like fields in a table

Former Member — Tue, 11 Sep 2007 18:39:53 GMT

How will it know to break at the 1st if I don't define it?

Re: summing like fields in a table

Former Member — Tue, 11 Sep 2007 18:46:04 GMT

Check the help for AT NEW. In part, it says:

The control level structure with internal tables is static. It corresponds exactly to the sequence of columns in the internal table (from left to right).

Rob

Re: summing like fields in a table

Former Member — Tue, 11 Sep 2007 18:54:54 GMT

Oh I see. I have several columns in between that i would not want it to sum by. Do you have another suggestion then instead of AT NEW

Re: summing like fields in a table

Former Member — Tue, 11 Sep 2007 18:58:50 GMT

I never use AT NEW or ON CHANGE OF. I find it easier to just keep track of it myself (using old_val and new_val or something like that). This way, I don't have to worry about the structure of the internal table - just the sorting.

Rob