Hello Everyone again;
i have a summary field of extended price and
in my payments i am attempting to perform a calculation within only the payments table.
However in trying to use only the payments table and selecting the totalInvoie summary to lookup , i only
get an empty set.
So i am using the long LINEITEMS::total ---> Payments::amountPaid
What i would like to do is use Payments::total ( lookup field ) --> Payments::amountPaid.
Can this lookup work with a summary ?