Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

not able to divide two columns RTF Template

55
Views
3
Comments

Content

we are trying to divide two columns but its not working.we are using the below code.

<?CURR_TOT_GAURENTEED_COMP?>DIV <?NEW_TOT_GAURENTEED_COMP?>

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • Rank 2 - Community Beginner

    Hi,

    Try the below expression it will work,

    <?CURR_TOT_GAURENTEED_COMP DIV NEW_TOT_GAURENTEED_COMP?>

    Thanks

    Nirmal

    http://www.dataterrain.com

  • Rank 2 - Community Beginner

    Hi @Nirmal-64675 ,

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

    ex: for one field: <?call-template:prj_accr1?>

    and for the second field: <?call-template:total_qty?>

    We would need to divide the 2 above ( + format the result).

    Thank you very much,
    Elena

  • 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

Welcome!

It looks like you're new here. Sign in or register to get started.