AGGR problem

[#1]

This should be easy...

I'm trying to create a line chart which simply takes the last Stock entry to date. Somehow it doesn't aggregates properlly.

The reason i've used date island is that the client want to see inventory stand to date even though there were no transactions in that date.

Chart type: Line chart

Dimmension: Year, MonthYear, Date

Expression:

=Aggr(
 max(
 if([Inventory Date] <=aggr(max(Date),Date) and [Inventory Next Date] > aggr(max(Date),Date), [Inventory Stock Qty],0
 )
 ),
 Date
 )

Ive attached file as example.