Sum of fields from different groups in Excel template

Mar 20, 2023 9:29AM

Hi all,

I'm using BIP 12.2.6.1.4 where I have a data model with 2 data sets.

I'm trying to show the data in Excel template where i would like to have a calculated field ( sum of 4 fields (2 from each group).

However, I'm not entirely sure what to do in the XDO_METADATA sheet.

The xml looks like the below :

<DATA_DS>

<P_LEDGER>300000001603025</P_LEDGER>

<P_LE>300000001597145</P_LE>

<P_FROM_DATE>2022-06-01T00:00:00.000+00:00</P_FROM_DATE>

<P_TO_DATE>2022-06-30T00:00:00.000+00:00</P_TO_DATE>

<G_OPERATING_FEE>

<LEGAL_ENTITY>06</LEGAL_ENTITY>

<PERIOD_NAME>16_Jun-22</PERIOD_NAME>

<GL_AMOUNT_NAT_ACC_5>0</GL_AMOUNT_NAT_ACC_5>

BI Publisher (MOSC)