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?