Skip to Content
0
Former Member
Nov 05, 2012 at 04:20 AM

Help in BEX report

27 Views

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.