On peoplesoft query manager I have the following expression

SUM(B.ENTRY_AMT * %DATEDIFF(B.ACCOUNTING_DT,A.ASOF_DT) )/ SUM(B.ENTRY_AMT)

B.ENTRY_AMT = amount of order
%DATEDIFF(B.ACCOUNTING_DT,A.ASOF_DT) = Days to pay each order

And this is returning the weighted average in which customer pays us.

Under Criteria I have set for Payment = PY, which means the order is closed. However, I was wondering if I could have that "where payment = "PY" inside the expression and not as a criteria.

I also want to add and return the total amount of open orders and if I have it under criteria I can't do it.

Can anyone help me with this.

Thank you