Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

How To get grand total in XML/BI publisher


You can use following  function out of  for loop to get grand total
<?sum(//CF_AMT_CHILD[.!=''])?>
Share this article :

4 comments:

  1. works for me!! Thanks!
    just for more clarity, here CF_AMT_CHILD is the name of the field whose sum is to be calculated

    ReplyDelete
  2. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  3. Hi
    Did you get a solution to this? Iam trying to create a report with group total then another total then grand total for the entire report.
    How do I start?
    BI publisher 11g.

    Thanks

    ReplyDelete