Waterfall chart end value not correct, always showing 0

[xingstar97]

I created a waterfall chart, x axis is datetime, start value is a column of 0, and end value is the difference between current and last price multiplied by current quantity. I used the code below:

start value: sum(start_value), start_value is a column of 0

end value: rangesum(avg(unit_mat_cost)*Sum(qty_received)-Sum(qty_received)*above(Avg(unit_mat_cost)))

The chart shows data correctly except the end_value is 0 instead of the sum of end value. See the attached screenshot of the data and chart. Any idea what happened and how to fix it?

[Rakan]

Facing the same issue, end value always showing 0. and when I use the same expression used for end value on a kpi it shows the correct value