Add fields values in Excel Template - BI Publisher
Hi All,
I have one customer requirement like below:
XDO_?XDOFIELD4? = XDO_?XDOFIELD1? + XDO_?XDOFIELD2? + XDO_?XDOFIELD3?
Where each field maps to below:
XDO_?XDOFIELD1? - <xsl:value-of select="sum(//Group_G1/AMT_1[text()])"/>
XDO_?XDOFIELD2? - <?AMT_2?>
XDO_?XDOFIELD3? - <?AMT_3?>
How to make addition in this type of case as XDOFIELD1 is little different i.e., Sum is calculated at runtime. Please provide your thoughts.
Thanks,