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,
