BI designer template : Sum values — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

BI designer template : Sum values

Received Response
32
Views
3
Comments
Lhoussain Benajam
Lhoussain Benajam Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

BI designer template : Sum values

Content

Hello,

We use Oracle BI Publisher Desktop 12.2.1.0.0 on word 2016 to builde BI template

Can you help us to write expression xsl to sum  2 values  ADHOC_SUCCESS_COUNT and ADHOC_FAILED_COUNT

Maybe it looks like : <?ADHOC_SUCCESS_COUNT? + ?ADHOC_Faild_COUNT?>

I attache screenshot to have more detailsAsk-C_template.PNG

Regards

Djam

Answers

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

    <?xdofx:ADHOC_SUCCESS_COUNT+ADHOC_FAILED_COUNT?>

    can you use the above

  • Lhoussain Benajam
    Lhoussain Benajam Rank 4 - Community Specialist

    hello Guys,

    Thanks a lot for your help, it's fix my  issue

  • Pavan kumar.
    Pavan kumar. Rank 5 - Community Champion

    Hi,

    Can you help us to write expression xsl to sum  2 values  ADHOC_SUCCESS_COUNT and ADHOC_FAILED_COUNT

    As this need to achieve through extended functions of SQL and XSLT, Can choose any of these functions but shouldn't club both functions in one expression. So you can get it summed up by following expression:

    <?xdofx:<field1>+<field2>?> this is followed by SQL Expression whereas <?xdoxslt?> is comes under XSL expression