Dear all,

I have a Table which Contains items and its prices and those prices some in Dollars and the rest in pounds and the items are divided into sections

and I want to use a modified Sum function in the Crystal Report so as to show at the end of each group the total in pounds

like that in C#

int price=0;
foreach (item it in items)
{ 
    if (it.curr=="$")
 { price+=it.price*DollarPrice }
else
price+=it.price;
    }
return price;

That's exactly what i want to do in crystal reports but i dont have any clue how to do so

So if you have any Idea please help me,

Regards,

Baher.