Newbie Questions

Re: Sum a repeting column in footer cell

xtothez — Tue, 23 Sep 2008 14:40:59 GMT

Thanks for the reply, I actually just found how to do it. When entering the formula, i had to use the full path of the "Item Total" field which was sum(../my:items/my:item/my:ExtPrice) and everything worked out great.

Thanks again.

Re: Sum a repeting column in footer cell

jrudolph — Tue, 23 Sep 2008 14:20:52 GMT

I would try something like this

Item	Amount of Item	ItemTotal
	Shipping	fx = your value
	Discount	fx = your value
	Subtotal	fx = sum(ItemTotal) + Shipping + Discount
	GST	fx = your value
	PST	fx = your value
	Total	fx =Subtotal + GST +PST

Sum a repeting column in footer cell

xtothez — Mon, 22 Sep 2008 23:51:19 GMT

Hi guys and gals,

I currently working on a purchase requisition for a sharepoint site. Essentially, i have a repeating table that lists the item number, the quantity of the items, description, unit price of the item and finally a final cell with the calculated value of Quantity * Unit price called extended price. I added a footer with 6 rows (shipping,discount,subtotal,GST,PST and Total) to the repeating table. I am desperately trying to sum the values of the Extended Price cell into the subtotal cell in my footer. I can't calculate anything from the Extended Price because i cannot select the Extended Price field when required. It's within a group and i can't get access to it.

What am i doing wrong? Can anyone help?