Please help I has a repeating table that has severla fields on it. There is a sum field based on quanity of units field that curently sum of anything in the QTY FIELD. I need to change this to sum based on what is selected from the lead type and sum only that lead type. Does anyone hav any suggestions ?
So - field2 should be the sum of Qty where Lead Type is equal to field4?
sum(../my:details[my:leadType = current()/../my:field4]/my:qty)
Omg thanks so much that is exactly what I was looking for!!!!! You are a life saver :)