Oracle Analytics and AI

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

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

RTF Template

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