Calculated Attribute Date calculation

[Vamshi_KVK]

Hello all,

 

I want to exclude weekends when calculating date difference in a calculated attribute of ca ppm. Does anyone know how to achieve that?

 

Thank you,

Vamshi.

[Sarmistha_Purkayastha]

Hi Vamshi,

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.

 

Regards, Sarmistha

[Kritika Rana]

Hi Vamshi,

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.