Duration field data issue in Sql tables in Project server 2013.

Question

Hi All,

I want to add duration column to the my SSRS report, But the data was showing wrongly in the sql server pwa table.

when i open project from ms project the duration was showing as 109.88 days but in the MSP_EpmProject_UserView or any other project tables the project duration was showing as 1359.5.

Can any one please help me which table and column name i need to take for the duration.

my environment is project server 2013 with latest August 2020 CU.

Answer 1

seems like, you CANNOT remove the decimals. This is because Microsoft Project Server 2013 tracks every Duration and Work value at the 1-minute level. I learned to live with the decimals many years ago. If you absolutely cannot live with the decimals for some strange reason, you could also use a custom enterprise Duration field with a formula and then round off the number.

Below article for reference:

https://social.technet.microsoft.com/Forums/projectserver/en-US/e4ba80d7-3462-4955-8854-ded44d174706/duration-decimals?forum=projectprofessional2010general

Thanks & Regards,

Answer 2

Hi @KOMMIREDDI KUMAR , thank you for posting in the Q&A forum.

Project Server is not currently supported here on Q&A.
Please find the active answering questions in dedicated forum here: https://social.technet.microsoft.com/Forums/projectserver/en-US/home?category=project

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
**Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. **

Answer 3

HI Sharatha,

Thanks for your reply, my question was not about removing decimals,

duration data was showing wrongly in the pwa tables--column.