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
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
you can try adding
to the end of the existing expression.