Formula to calculate % available in Project Server

1 – CASE WHEN dbo.MSP_EpmResourceByDay_UserView.Capacity > 0 THEN (ISNULL(dbo.CADTH_AssignmentWorkbyDay.AssignmentWork , 0) / ISNULL(dbo.MSP_EpmResourceByDay_UserView.Capacity , 0)) ELSE 0 END

This formula converts any null values to 0 and then checks for divide by 0, 0 present, skips it with the case Statement.

 

JIm

Advertisements