I have a Report that includes a calculation for "days overdue" of a Case (Due Date - Closed Date). SFDC is calling this field CDF1.
I want to add a calculation for the average days overdue but ONLY including cases that are closed overdue (so lines where the Due Date - Closed Date value is < 0) in the calculation.
I tried the calculation IF(CDF1:UNIQUE < 0, CF1:AVG, 0), but this returned 0 for all fields, even where the CDF1 was negative.
I also tried IF(CDF1 < 0, CDF1:AVG, 0), but SFDC told me "Field CDF1 does not exist"