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"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.