I am new to XSLT. I have the following XML source structure:
<CURRENT_INCOME IncomeType="BASE" _MonthlyTotalAmount="25000.0000" />
<CURRENT_INCOME IncomeType="BASE" _MonthlyTotalAmount="25000.0000" />
<CURRENT_INCOME IncomeType="BONUS" _MonthlyTotalAmount="0.0000" />
<CURRENT_INCOME IncomeType="COMMISSIONS" _MonthlyTotalAmount="0.0000" />
<CURRENT_INCOME IncomeType="OVERTIME" _MonthlyTotalAmount="0.0000" />
I need to sum MonthlyTotalAmount amount based on IncomeType.
Output need look like below:
<CURRENT_INCOME IncomeType="Base" _MonthlyTotalAmount="5000.00" />
<CURRENT_INCOME IncomeType="Bonus" _MonthlyTotalAmount="0.00" />
<CURRENT_INCOME IncomeType="Commissions" _MonthlyTotalAmount="0.00" />
<CURRENT_INCOME IncomeType="Overtime" _MonthlyTotalAmount="0.00" />
Any small help will be much appreciated.
No comments:
Post a Comment