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
