My request is to create a chart that shows the evolution of the orderbook: the SUM of Amount ordered and Not Shipped in a per-day basis.
The result (Orderbook) should show something like this:
Date
Orderbook
01/09/2016
97 (+27+70)
02/09/2016
245 (+148)
03/09/2016
249 (+31-27)
04/09/2016
208 (+22-63)
05/09/2016
138 (-70)
06/09/2016
22 (-85-31)
07/09/2016
2 (-20)
The expression I have tried is similar to :
=sum ({< Date = {"<=$(=date(ShipmentDate),'DD/MM/YYYY') >= $(=date(OrderDate),'DD/MM/YYYY')"} >} OrderAmount)
But as the Date field has always the same value as the OrderDate, the calculation is not correct. Is the data model ready for this calculation? Would the solution be to create new field with all dates?
