BI Publisher sum values

Benoit Lanoir · May 8, 2017 7:00AM

Summary

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

Sherry George · May 8, 2017 7:00AM

For total you can use this.

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

Benoit Lanoir · May 8, 2017 7:00AM

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

Aira Viene · Jun 6, 2025 8:49AM

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?