Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

How to do total SUM?

edited Dec 9, 2016 4:00AM in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered

In driver section A of my UBE, it has a level break footer on employee's number.  The sequence is set up using employee number. In this LBF, I want to sum up the employee's commissions.  I have the business view commission  field on section A and the LBF section.  I right click mouse on the commission field in the LBF and under the totaling tab, I checked the Total checkbox and selected Sum.

So let's say there are two records of employee 123456 and the commission field has 100 and 200 respectively.  The total should be 300.

But after I ran it, the commission field in the LBF contains some random number.

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