Hello Experts,
Please help me with the following requirement in i BEX Report
CUST NO INvoice NO Days LAte INV Amoount Weighted Average days
XYZ A -9 100
XYZ B 2 200
XYZ C -5 300
XYZ D 0 400
In the last coloumn I want a calculaton as following.
ONly invoices paid late should be considered (DAys late -ve ).
Multiply the Invoice amounts where days late is nagative with days late and then divide by the sum of invoice amounts late
(-9*100) + (-5*300)
---------------------= Weighted Average days= -6 days late
400
Could you please let me know how to get this done on the BEX query designer.