Avg of row above

[kylealpaugh]

I have a chart where i need to get the Mont to date avg I have the following expression

Rangeavg(Above(Sum({<Year={$(vCurYear)}>}$(vAmountField(Billing Net Value))), 0, RowNo()))/1000

This works but some of the days in the month like weekends have no sales and i only want to calcuate days that have sales.

I would like to show the second line in the avg per day column to be 2017 and not count rows that are 0.

Thanks

[sunny_talwar]

2017? How did you come up with that number from?

[kylealpaugh]

miss typed meant to be 207

[sunny_talwar]

May be this

RangeAvg(Above(

If(Sum({<Year = {$(vCurYear)}>} $(vAmountField(Billing Net Value))) > 0, Sum({<Year = {$(vCurYear)}>} $(vAmountField(Billing Net Value))))

, 0, RowNo()))/1000