How to get Target percentage completion in SQL through query | MS Project server or MS project professinal plan RRS feed

  • Question

  • Hi Team,

    Unable to fine target percentage completion in the sql through query in MS project server. actually I am using below the formula which is get incorrect target percentage completion :

    =100*ProjectBaseline0StartDate-getdate() / ProjectBaseline0StartDate-ProjectBaseline0FinishDate

    According to my screenshot how can I get exact target percentage completion(i.e. 67%) in the sql query.

    Harjinder kumar SharePoint Developer

    Wednesday, March 1, 2017 1:20 PM


All replies