Average showing "-"

[bellesol]

Hi,

I'm trying to calculate the average of sales of the last three months and I'm getting the result = "-"

The case is like this:

I have a customer that did a sale on 02.2020

so when I'm trying to calculate the average sale of this customer of the last three months (7-10.2020) I'm getting the result "-" instead of "0" because he didn't have a sale on this months.

I'm using this calculation:

Avg({<[ Sales Deal Flag]={'N'},[Month Diff]={"<=$(vMaxMonthDiff)>=$(vMaxMonthDiff-3)"},Month=,Year=,Qtr=>}[Trans Sales])

Thanks in advence,

[Kushal_Chawda]

@bellesol  How you want to represent the Avg? I mean which chart? What would be the dimension?

[bellesol]

Hi,

straight table and the dimension is customer