I want to exclude weekends when calculating date difference in a calculated attribute of ca ppm. Does anyone know how to achieve that?
Check out the Calculated Attributes topic in the following documentation. You may get some insight.
CA PPM Studio Objects and Attributes- 15.4 (SaaS)
Let us know if you have any feedback.
Following logic gives the number of working days excluding weekends in sql,
datediff(dd, inv.schedule_start, inv.schedule_finish) - (datediff(wk, inv.schedule_start, inv.schedule_finish) * 2) - case when datepart(dw, inv.schedule_start) = 1 then 1 else 0 end + case when datepart(dw, inv.schedule_finish) = 1 then 1 else 0
You can use above logic to build your expression in calculated attribute.
Retrieving data ...