Hello,
I’ve this formula to determine the project days and its based on the status of the project. If project status is commenced I need to count the days between the {Intro Call Date} and {Commencement Date}. Else it is difference between {Intro Call Date} and Today ().
Getting the error one of the parameter is invalid on items where the status is not “Commenced”.
35 is the KPI days, so the project days increments from -35.
Also, as a general rule, I would recommend using FORMAT_DATE() instead of ROUNDDOWN() in these types of date formulas (for any dates within the last 100 years). (it’s just more correcter )