Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Total of a field in BI Publisher — Cloud Customer Connect
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

Total of a field in BI Publisher

Received Response
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment


Total 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)?>

Howdy, Stranger!

Log In

To view full details, sign in.


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