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