BI Rtf template : Write expression in XSL — Oracle Analytics

Oracle Analytics Cloud and Server

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

BI Rtf template : Write expression in XSL

Received Response
53
Views
2
Comments

Summary

BI Rtf template : Write expression in XSL

Content

hello,

     can you help as to write an expression XSL to use addition, multiplication and division :

     We need to compute the value of  :

              (A+B)*100/(C+D)

    I write intuitively :   <?xdofx:(A+B)*100/(C+D)?>, but the result is wrong, it only display the value of A+B !

    Regards

   Djam

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    You can use below in xslfo.

    Please note that division operator is Div in 11g onward . Before that division operator was / in 10g 

    <?xdofx:to_number((A+B)*100 Div (C+D))?>

    In core XSL you can write below

    <xsl:value-of select="number((A+B)*100 div (C+D))"/>

  • Lhoussain Benajam
    Lhoussain Benajam Rank 4 - Community Specialist

    Thank you Shukla, it's help me  :-) :-)

    Have a good day

    Djam