Try this:
.if.documentitems->manufacturerpartnumber="HE_10GB_1YR".then.documentitems->ExtendedPrice at the line item (detail section) level.
Then copy that into one of the footer sections and double-click on it.
you should then be able to set the summarisation type to Total.
Hi Matt... it works!
Thank you so much!
You're most welcome! :)
Angelique Oosthuizen
I am trying to create an agreement and need to add certain unit prices based on the manf part number, but the formulas that I am trying is causing an error in QW and then the program shuts down.
.if.documentitems->manufacturerpartnumber=HE_10GB_1YR.total-of.documentitems->unitprice
I am assuming that there is a problem in the formula. When I copy and paste an external formula the system continues.
What would be the correct formula to use in this instance?