% Calculation for Date Differences

Discussion created by CindyK on Nov 6, 2012
Latest reply on Nov 14, 2012 by navzjoshi00
I have been trying to create a new attribute that would calculate the % increase between two dates and can't seem to get it to work. Can anyone assist me?

Dates using:
Project Start Date (using OOTB field)
Project Finish Date (using OOTB field)
Proposed Finish Date (new attribute)

I created new fields using DateDiff to determine the number of duration betwen the Start and Finish dates. These calculations worked correctly. I just can't seem to get the % field to work.

I want to determine the % increase between the Project Finish Date and the Proposed Finish Date - for instance, does the proposed finish date result in a 15 % increase to the project schedule.

Thanking the community in advance for your help,