Count and Sum

Source:

<Detail>

<Status>approved</Status>

<Amount>1001</amount>

</detail>

<Detail>

<Status>SL no not mentioned(not approved)</Status>

<Amount>15</amount>

</detail>

<Detail>

<Status>Name Blank(not approved)</Status>

<Amount>20</amount>

</detail>

<Detail>

<Status>approved</Status>

<Amount>67</amount>

</detail>

Target

<Record>

<CountOfApprovedRecord>2</CountOfApprovedRecord>

<totalAmountApproved>1068</totalAmountApproved>

<CountOFNOTApprovedRecord>2</count>

<totalAmountNOTApproved>35</totalAmount>

</record>

Subject edited by: Moderator on Nov 13, 2010 10:10 PM

Edited by: Debashish Roy on Nov 14, 2010 7:32 AM