Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Sum a column

edited Aug 20, 2014 5:02AM in Design Tools & Output Technologies - JDE1 (MOSC) 11 commentsAnswered

I have following fields in a temp table and the business view is based on this table"

F55XXXX

A*         B*               C*               D             E@

1           W               X                    1              Z

2           K               L                     6              Z

3           P               Q                   8               Z                        

4           H               I                     2              N

5            R               S                  9               N      

Where A,B,C with * are primary keys and E with @ is the sorted column.

Now I want to print the totals for D wherever the the value of E@ changes. In the above example the changes happen in row 3 and row 5 (last row). The report should print following:

E@      Total D

Z           15         (1+6+8)

N           11         (2+9)

I have tried using the following:

Where BC E  = PC E

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center