Running Total problem in xdoxslt with xdofx formula — 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

Running Total problem in xdoxslt with xdofx formula

Received Response
266
Views
8
Comments
John Bruso1
John Bruso1 Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

Summary

How to build a running total with xdoxslt:set_variable when it contains a xdofx formula

Content

Hi All,
 
I am building a BI Publisher RTF report. I am trying to build a running total for a field that has the following formula:
 
<?xdofx:
(
WYO_AMEND_FEE_1 + WYO_AMEND_FEE_2 + WYO_AMEND_FEE_CONS + WYO_AMEND_FEE_OTH + WYO_ORIG_FEE_1 + WYO_ORIG_FEE_2 + WYO_ORIG_FEE_CONST + WYO_ORIG_FEE_OTH
) - 
(
MONETARY_AMOUNT +MERCHANDISE_AMT + WYO_AMT_PD_1+WYO_AMT_PD_2+WYO_AMT_PD_CONS+WYO_AMT_PD_OTH
)?>
 
I am using the following method
 
Set RTotVarCONBAL to 0 at top of page...
<?xdoxslt:set_variable($_XDOCTX, 'RTotVarCONBAL', 0)?>
 
Build and print Running Total in the body...
<?xdoxslt:set_variable($_XDOCTX, 'RTotVarCONBAL', xdoxslt:get_variable($_XDOCTX, 'RTotVarCONBAL') + (xdofx:
(
WYO_AMEND_FEE_1 + WYO_AMEND_FEE_2 + WYO_AMEND_FEE_CONS + WYO_AMEND_FEE_OTH + WYO_ORIG_FEE_1 + WYO_ORIG_FEE_2 + WYO_ORIG_FEE_CONST + WYO_ORIG_FEE_OTH
) - 
(
MONETARY_AMOUNT +MERCHANDISE_AMT + WYO_AMT_PD_1+WYO_AMT_PD_2+WYO_AMT_PD_CONS+WYO_AMT_PD_OTH
)) )?>
 
<? xdoxslt:get_variable($_XDOCTX, 'RTotVarCONBAL')  ?>
 
Print Total
<?xdoxslt:get_variable($_XDOCTX, 'RTotVarCONBAL') ?>
 
ERROR
The error I'm getting is:
[082918_154651385][][ERROR] [Line 443.43] Incorrect XPath: xdoxslt:set_variable($_XDOCTX, 'RTotVarCONBAL', xdoxslt:get_variable($_XDOCTX, 'RTotVarCONBAL') + xdofx:
(
WYO_AMEND_FEE_1 + WYO_AMEND_FEE_2 + WYO_AMEND_FEE_CONS + WYO_AMEND_FEE_OTH + WYO_ORIG_FEE_1 + WYO_ORIG_FEE_2 + WYO_ORIG_FEE_CONST + WYO_ORIG_FEE_OTH
) - 
(
MONETARY_AMOUNT +MERCHANDISE_AMT + WYO_AMT_PD_1+WYO_AMT_PD_2+WYO_AMT_PD_CONS+WYO_AMT_PD_OTH
))


Thanks for your help!

:) John

Tagged:

Answers

  • Saresh-Oracle
    Saresh-Oracle Rank 5 - Community Champion

    Hi John,

    Please let us know the version of BIP.
    Found a Bug 19933387 - STRESS:FA:PRC:INCORRECT XPATH ERROR SEEN IN BIPUBLISHER.LOG on BIP 11.1.1.9.

    Can you raise a SR with Oracle Support with rtf template and xml data?

    Thanks,
    Sareesh

     

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Thank you Sareesh.

    I'm not able to find that Bug in Oracle support. maybe I'm searching incorrectly.

    I can create an SR through my Oracle Support account. Is there a patch for the problem or some other fix?

    Thanks,

    John

  • Saresh-Oracle
    Saresh-Oracle Rank 5 - Community Champion

    Hi John,

    I did not see any patch . But development team will review your rtf template and xml data and suggest a fix.

    Thanks,
    Sareesh

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Ok, thanks Sareesh. And, yes, that is my version of BIP.

    BIP_Version.PNG

  • Saresh-Oracle
    Saresh-Oracle Rank 5 - Community Champion

    Hi John,

    Please log a SR for this issue.

    Thanks,
    Sareesh

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Yup, it's created. 3-18212685491

  • Saresh-Oracle
    Saresh-Oracle Rank 5 - Community Champion

    Thats good.

    I will monitor the SR .

    Regards,
    Sareesh

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    fyi, Sareesh, had to create a new SR for this: SR 3-18297137441