You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Expression

1 reply [Last post]
Guest's picture
Guest

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

Sean Carroll's picture
Sean Carroll (not verified)
Re: Expression

you can try adding

AND B.PAYMENT = 'PY'

to the end of the existing expression.