My name is Mario, t his is the need of my company: A field that should include by default in the system is to obtain the "Percentage Advance Planned" to compare with the Percentage Real Progress of the projects. Thanks in advance -- Arq. Mario Francisco Vázquez Cruz Jefe de Proyectos Sr Soporte Inmobiliario Servicios Liverpool S.A. Tel. 5268-3000 Ext.1541 Fax 5268 – 3353 Correo electrónico: "mailto:mfvazquezc@liverpool.com.mx" mfvazquezc@liverpool.com.mx Conoce la gama de servicios que te ofrecemos, entra a nuestro portal: "https://sites.google.com/a/liverpool.com.mx/direccion-corporativa-de-inmobiliaria/" style="color:rgb(17,85,204)" https://sites.google.com/a/liverpool.com.mx/direccion-corporativa-de-inmobiliaria/ El Cliente y el servicio también son parte de MI vida. ¿Cómo te estoy atendiendo? Por favor contacta a mi jefe, Ana María Peredo para cualquier retroalimentación "mailto:aperedo@liverpool.com.mx" aperedo@liverpool.com.mx
Hi Mario, I was wondering if you can provide a little more detail or a use case explaining what information you expect this field to provide? Thanks! David DAVID A. TAYLOR Founder & Managing Consultant
For example, in Microsoft Project, when the entire project has already been programmed and it has been a while since the start date, you can take the planned advance calculation and compare it with your actual progress. PLAN Vs REAL Mario Francisco Vazquez Cruz Servicios Liverpool SA de CV
Hello, If you are assuming some linear progression in the system (which is not always true for a variety of reasons) you could calculate this by the following expression:
ROUND(
PROD(
DIV(
DATEDIFF(actualStartDate,$$TODAY),
DATEDIFF(plannedStartDate,plannedCompletionDate)
),
100),
2)
Dale Whitchurch Arthrex Inc
Hi Mario. I think what you are looking for is already in the system as the Schedule Performance Index (SPI). Please review the following links: "https://support.workfront.com/hc/en-us/articles/216632068-Calculating-Schedule-Performance-Index-SPI-">https://support.workfront.com/hc/en-us/articles/216632068-Calculating-Schedule-Performance-Index-SPI- "https://support.workfront.com/hc/en-us/articles/216744418-Understanding-Project-Finances">https://support.workfront.com/hc/en-us/articles/216744418-Understanding-Project-Finances David Cornwell
