Skip to main content
Solved

Project summary generic inquiry - Estimated completed % formula

Hi,
 

 

Could someone assist me with modifying the formula in the attached project generic inquiry?

I want the "Estimate Completed % field to display zero if the revised estimate is zero. Currently, it shows 100% even when there is no cost budget defined for the project. Please refer to the attached generic inquiry for details.

 

 

3 replies

ejmillar
Rank
Userlevel 5
Badge +1

Hello,

 

I’ve looked at the formula which calculates the estimate completion %. The first IIF statement checks whether the PMBudget.CuryActualAmount is greater than zero.

If this is true then the result of the formula is subtracted from 100 highlighted below…

If the PMBudget.RevisedAmount is zero and you are subtracting zero from 100 then the result would be 100.

I would fix this by checking that PMBudget.CuryActualAmount > 0 AND  [PMBudget.RevisedAmount] > 0

Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
P
Rank
Userlevel 3
Badge

Hi @ejmillar 

Appreciate your help.

I’ve changed the entire formula to [(cost to date / revised estimate ) * 100 ] to get correct value and it’s working perfectly.

I’ve added revised formula for your reference. 

=IIF(SUM(IIF([PMBudget.Type] = 'E', [PMBudget.RevisedAmount], 0)) = 0, '0.00',     ROUND((SUM(IIF([PMBudget.Type] = 'E', [PMBudget.CuryActualAmount], 0)) /     SUM(IIF([PMBudget.Type] = 'E', [PMBudget.RevisedAmount], 0))) * 100, 2))


Thanks :-)

Chris Hackett
Rank
Userlevel 7
Badge

Thank you for sharing your solution with the community @psoni1585!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings