Total of a field in BI Publisher
SummaryTotal of a field in BI Publisher
I'm working on a report on which I want to display the total of Transport Handling Units (THU's) validated, currently displaying "0" in my report.
It's the same principle as my field SHIP_UNIT_COUNT (which displays the total of Ship_Unit per Stop in my report) but my field "THU_VALIDATED" is in another Data Set of my Data Model.
These are the codes :
Ship_unit_count (Data set ITEM) : <?sum(current-group()/ITEM[PACKAGING_UNIT_GID='-']/SHIP_UNIT_COUNT)?>
THU_validated (Data set shipment_debrief) : <?sum(current-group()/SHIPMENT_DEBRIEF[PACKAGING_UNIT_GID='-']/THU_VALIDATED)?>