Payment Application BP: Upper Form not being auto-populated from the Detail form as expected.

Hi,

I have the following DE in the upper form that are being auto-populated from the detail form (Detail form of this BP(sum of all lines)). Some of these DEs are not being auto-populated as expected.

DEs in Upper Form:

1. Total Completed and Stored to Date - WORKS
2. Less Previous Certificates for Payment - WORKS
3. Total Retention - Only autopopulated the line items that are currently being invoiced on the current PayApp record.
4. Total Earned Less Retention - WRONG because of Total Retention amount
5. Current Payment Due - WRONG because of Total Retention amount
6. Balance to Finish - WRONG because of Total Retention amount