Formula to calculate percent of total in BI Publisher
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))?>