Line chart - Discontinue line when no more values to accumulate

[geof]

Hi

I have a line chart that graphs the accumulated (running sum) of daily sales. I have used this expression which I found in this community (thanks):  

Sum(Aggr(RangeSum(Above(Sum(this_year_daily_total), 0, RowNo())) , day))

I would like the line to end when there are no more values to accumulate, i.e. when the chart reaches the 'current' day. I guess I would need to use the Below() function but I am not sure how to evaluate till the end of the month. Also is it possible to stop the line being drawn?

In the attached image, the arrows points to where I would like the line to stop.

The data contain rows:

Month, Day, Product, ValueSold

The values for all products are summed for each day and accumulated for each day and each month.

[Aasir · Accepted solution]

if(day <= day(today()), Sum(Aggr(RangeSum(Above(Sum(this_year_daily_total), 0, RowNo())), day)), null())

[geof]

Very nice! The solution is exactly what I wanted. Thank you.