Sum field in detail section - is this possible?

[Corinne]

Can anyone help me do something that I thougt would be very simple? I need to have the data show as in the example below:
Detail Section:
Item Count Item Price (Cost of item which is not shown)
2 20.00 10.00
1 10.00 10.00
3 15.00 5.00

Group Footer:
6 45.00

My problem is when the item count is greater than 1 how do I get the extended values into the Item Price column? Currently I have a sum field in the group footer that does calculate correctly:

Detail Section:
2 10.00 10.00
1 10.00 10.00
3 5.00 5.00

Group Footer:
6 45.00


Thanks to anyone that can point me in the right direction.

Corinne

 

[kchaudhry]

You can create a formula like this:

@ExtendedPrice

{Table.ItemCount} * {Table.ItemPrice} //replace with your own field.

Place this formula in the details section.

Hope this helps!

Kchaudhry

 

[Katy44]

I don't think I really understand your problem. have you created a formula which does Item Count x Cost of item? What does that show if you put it in the details section?