Summary BI Publisher sum values Content Hi all, I am trying to create into a .rtf Template a total row with the sum of the values below : 1 324 1170884 2 294725829 8233780 3 -2941894 8233780 I cannot group by my value to sum it after. Any idea on the best way to do it directly in the Template ? Best regards, Ben

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

BI Publisher sum values

Benoit Lanoir

Summary

BI Publisher sum values

Content

Hi all,

I am trying to create into a .rtf Template a total row with the sum of the values below :

<DATA_DS>

<G_1>

<LINE_NO>1</LINE_NO>

<AMT_POS>324</AMT_POS>

<AMT_SEC>1170884</AMT_SEC>

</G_1>

<G_1>

<LINE_NO>2</LINE_NO>

<AMT_POS>294725829</AMT_POS>

<AMT_SEC>8233780</AMT_SEC>

</G_1>

<G_1>

<LINE_NO>3</LINE_NO>

<AMT_POS>-2941894</AMT_POS>

<AMT_SEC/>8233780</AMT_SEC>

</G_1>

</DATA_DS>

I cannot group by my value to sum it after. Any idea on the best way to do it directly in the Template ?

Best regards,

Ben

Find more posts tagged with

Accepted answers

Sherry George

For total you can use this.

<?xdoxslt:sum(//AMT_SEC)?>

All comments

Benoit Lanoir

It worked ! I tested that solution and i just realized that it didn't worked because i forgot a '/' in my <?xdoxslt:sum(/AMT_SEC)?>

Thanks again ! Really appreciated.

Best regards,

Ben

Sherry George

For total you can use this.

<?xdoxslt:sum(//AMT_SEC)?>

Aira Viene

Hello @Sherry George can you explain further on how I can use

<?xdoxslt:sum(//AMT_SEC)?>, does AMT_SEC means the tokens that you will be adding?