You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to sum at highest level of grouping on rtf

Summary:

I need to sum at the highest level of grouping in my rtf

Content (please ensure you mask any confidential information):

I am building a rtf template for a report. This report first groups by employee and then groups by timesheet id. The timesheet id is then displayed with various elements of the employee below that.

First group is: <?for-each-group:row;./A.EMPLID?><?sort:current-group()/A.EMPLID;'ascending';data-type='text'?>

Send group is: <?for-each-group:current-group();./A.TIME_SHEET_ID?><?sort:current-group()/A.TIME_SHEET_ID;'descending';data-type='number'?>

Currently I am using <?sum(current-group()/B.TIME_QUANTITY)?> to sum the circled red amout above, but this is wrong as it is giving me the total sum for the element A.TIME_SHEET_ID. I want to sum for the group A.EMPLID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!