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?
