Hello all. First post, so please forgive my ignorance...
I am trying to put together a quarterly chart that shows the average open warranty days that ignores any date filters applied. When I put this formula in, it doesn't ignore my date filters that I put in here to ignore. If I take the top part of the equation (before the '/'), it works. The bottom part after the '/' does not. The formula itself is coming back with the right numbers. I just can't get it to ignore any date filters
I'm not sure what to do here. Any help would be greatly appreciated and I thank you for your efforts.
Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
Aggr(Avg({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
Aggr(If(Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=,
[CaseStatusDt.calendar_year]=,[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
CaseMonthCloseCnt)= 0,Max({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=,
[CaseStatusDt.calendar_year]=,[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
CaseMonthAgingDays)),CaseNbr,Emp_Name,[CaseStatusDt.CaseFiscalQtrYr])),Emp_Name,[CaseStatusDt.CaseFiscalQtrYr]))
/
Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
Aggr(Count({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
DISTINCT Aggr(If(Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=,[CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
CaseMonthCloseCnt)= 0, Emp_Name),CaseNbr,Emp_Name,[CaseStatusDt.CaseFiscalQtrYr])),Emp_Name,[CaseStatusDt.CaseFiscalQtrYr]))
