Hi everybody,
How to summarize the Dynamic column in rtf template (use the split-column)
Now I have used the split-column function to do my dynamic column in rtf template. But now need to do sum for the every dynamic column. I don't know how to do deal with this sum?
The fllowin is my xml file, I want to sum the Basic Salary and Bonus columns(These two are Dynamic columns). Is there has any good idea?
This is my xml file.
<?xml version="1.0" ?>
- <Root xmlns:xsi="
www.w3.org/2001/XMLSchema-instance">
- <MAIN>
<PERIOD_YEAR>2011</PERIOD_YEAR>
<PERIOD_MONTH>11</PERIOD_MONTH>
- <COMPANY_G>
<COMPANY>AGO</COMPANY>
<COMPANY_D_T>Foshan Company</COMPANY_D_T>
- <DEPT_G>
<SETID_DEPT>CCHPR</SETID_DEPT>
<DEPTID>00008</DEPTID>
<DEPTID_D_T>Foshan Project</DEPTID_D_T>
- <SALARY_DETAIL>
<COMPANY_DESCR>Foshan Company</COMPANY_DESCR>
<DEPT_DESCR>Foshan Project</DEPT_DESCR>
<EMPLID>00013666</EMPLID>
<EMPL_RCD>0</EMPL_RCD>
<EFFDT>2011-04-02</EFFDT>
<EFFSEQ>0</EFFSEQ>
<LAST_HIRE_DT>2010-06-17</LAST_HIRE_DT>
<TERMINATION_DT />
<EMPL_NAME tyname="yyy">Qiu Qiulong</EMPL_NAME>
- <CF_COLUMN ColId="010">
<CFName typetitle21="PRI">Basic Salary</CFName>
</CF_COLUMN>
- <CF_VALUE2 ColId="010">
<CFValue2 typetitle22="PRI">1600</CFValue2>
</CF_VALUE2>
- <CF_COLUMN ColId="015">
<CFName typetitle21="PRI">Bonus</CFName>
</CF_COLUMN>
- <CF_VALUE2 ColId="015">
<CFValue2 typetitle22="PRI">12</CFValue2>
</CF_VALUE2>
</SALARY_DETAIL>
- <SALARY_DETAIL>
<COMPANY_DESCR>Foshan Company</COMPANY_DESCR>
<DEPT_DESCR>Foshan Project</DEPT_DESCR>
<EMPLID>00013666</EMPLID>
<EMPL_RCD>0</EMPL_RCD>
<EFFDT>2011-04-02</EFFDT>
<EFFSEQ>0</EFFSEQ>
<LAST_HIRE_DT>2010-06-17</LAST_HIRE_DT>
<TERMINATION_DT />
<EMPL_NAME tyname="yyy">Qiu Long</EMPL_NAME>
- <CF_COLUMN ColId="010">
<CFName typetitle21="PRI2">Basic Salary</CFName>
</CF_COLUMN>
- <CF_VALUE2 ColId="010">
<CFValue2 typetitle22="PRI2">2600</CFValue2>
</CF_VALUE2>
- <CF_COLUMN ColId="015">
<CFName typetitle21="PRI2">Bonus</CFName>
</CF_COLUMN>
- <CF_VALUE2 ColId="015">
<CFValue2 typetitle22="PRI2">12</CFValue2>
</CF_VALUE2>
</SALARY_DETAIL>
</DEPT_G>
</COMPANY_G>
</MAIN>
</Root>
