Hi, My requirement is to group by in RTF template and sum the amount fields. I could acheive group b

Hi, My requirement is to group by in RTF template and sum the amount fields. I could acheive group by based on the syntax for-each-group. But i could not sum the amounts. I am using the syntax to do sum is: <?sum(current-group()/amount)?>. But this is always ending in xdo error.

Requirement: description   amount

                      xyz             100

                      xyz              200

I need to group by based on description and i could acheive this by using for-each-goup.

But i could not sum the amounts. Result should display like below.

Description amount

xyz              300

Could you please help me on this

Thanks,

Rajesh.