次の方法で共有


Round actual work values in reporting view "MSP_AssignmentByDay_UserView"

  Sometimes, in Project Server and Project Professional, there are values of Actual Work diferent to Actual Work in the reporting view "MSP_AssignmentByDay_UserView". For example, in Project Server and Project Professional in these assigns, for the day 22 of october do 2014, the values of Actual Work are 0,97 h

 But in reporting view "MSP_AssignmentByDay_UserView" , the values are diferent. if we round with T-SQL Round function with two decimals, the results will be 0,96 h, diferent value to Project Server and Project Professional. if we group by resource and sum these "Actual Works" the results will be different from Project Server..

AssignmentUID

Date

Actual Work

B5D5C2AF-

22/10/2014

0.962250

23385105-

22/10/2014

0.962267

33DD6D0F-

22/10/2014

0.962250

A new view based on "MSP_AssignmentByDay_UserView"  can be created to solve this problem. In this new view, a new field "Actual work rectificado", can be created with a custom round (round(round([AssignmentActualWork]*60000*0.001,0)/60,2) as [AssignmentActualWork rectificado]). Users can work with this new value. 

create
view [dbo].[Custom_EpmAssignmentByDay_UserView]
as

SELECT
[AssignmentUID]
,[TimeByDay]
,[ProjectUID]
,[TaskUID]
,[AssignmentWork]
,[AssignmentActualWork]
,round(round([AssignmentActualWork]*60000*0.001,0)/60,2) as [AssignmentActualWork rectificado]
,[AssignmentActualWork]-round(round([AssignmentActualWork]*60000*0.001,0)/60,2) as Diferencia

 FROM [dbo].[MSP_EpmAssignmentByDay_UserView]