It works fine, except I want this "ListPriceTotal" only to include items that have a Qty attached. It right now is populated via XML with the ListPrice dynamically populated. I don't have room to make another column to "Hide" this total, I would like to use FormCalc.
I have tried the following without any luck, as it only totals the first row from each section and not the rows following within the same section:
Sum (ProductRow1[*].ListPrice * ProductRow1[*].Qty)
Basically here is what I would like to see happen....
Item# Qty ListPrice DicsountPrice RowTotal
ABCD 2 $500 $400 $800
WXYZ 3 $250 $200 $600
I want to see the ListPriceTotal field to show $750 in the above scenario.
If item # WXYZ quantity = 0 then the ListPriceTotal field would show $500