How to determine field = division of two other fields, called from different templates?

Elena Ramona

Hi,

We have a BI publisher report, with .rtf template.

Any idea how we can divide two fields that we get by calling templates:

ex: for one field:

<?call-template:prj_accr1?><?format-number:xdoxslt:get_variable($_XDOCTX, ‘prj_accr1’);'999G999G990D00'?>

and for the second field:

<?call-template:total_qty?><?format-number:xdoxslt:get_variable($_XDOCTX, ‘total_qty’);'999G999G990D00'?>

We would need: prj_accr1 / total_qty.

Any idea, please, which should be the correct syntax?

Thank you very much,

Elena

Rajasekhar Bandaru-Oracle

Hi Elena

Please review the given help center documentation link and follow the recommendations.

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/extended-sql-and-xsl-functions.html#GUID-B39D756A-C54D-4C64-A822-DD2CFFC3A54E