Supply Chain Management - PSFT (MOSC)

MOSC Banner

Formula to calculate percent of total in BI Publisher

edited Aug 8, 2019 2:15PM in Supply Chain Management - PSFT (MOSC) 5 commentsAnswered ✓

Good morning,

My company uses PeopleSoft Enterprise and I'm in the process of converting all our Crystal reports to BI Publisher. Several of our Crystals calculate the percent of total and I've been unable to figure out how to do that in the Word rtf template for BI Publisher.

For example, I created an rtf template where I'm grouping by Operating Unit (group above) which displays the number of POs and merchandise amount by date range for each operating unit.

To count the # of POs for each operating unit, I'm using this formula:

<?count(xdoxslt:distinct_values(current-group()/PO_ID))?>

Tagged:

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