Skip to Content

Getting 1 average per customer on every line


I'm currently creating a report where I need the average days open per customer, filled on every document line. The ultimate goal of this report is creating a forecast regarding collectibles.

My report looks like this:

In the report, every invoice has been paid. So the document date and payment date are known. For every invoice, the days open are calculated by subtracting the [Document date] from the [Payment date]. This is done with the [Days open] measure.

I have tried multiple variations of In, ForAll and ForEach to calculate the Average Days open. The one that makes the most sense to me is: =Average([Days open]) In([Relation Name]). I have read guides on these functions, but I can't seem to figure out why I am not getting the desired result.

Some variations give the #MULTIVALUE error, others copy the [Days open] per line. In this case, I would like the average days, 19.66 in this example, to be seen on every line. This because I would like to implement this in our aging report, so a forecast can be made on invoice-level. Hence, the break function is not an option for me.

Does anyone have some input for me? Help would be much appreciated!

sap-question.png (15.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers