AnsweredAssumed Answered

Calculated Field DateDiff Help Needed

Question asked by Liz_Williamson on May 30, 2012
Latest reply on Jan 23, 2013 by Juan_Ortega
I am trying to create a calculated attribute using DateDiff. I am looking for the variance between the difference of start date to two different dates and then dividing that by the a date difference to get the percentage. I cannot get the calculation to show anything but 0.00 when I divide.

My example is

DateDiff(schedule_start,golive,"Day")-DateDiff(schedule_start,absg_bgldt,"Day")/DateDiff(schedule_start,golive,"Day")

When I do the first part it works but when I add the third part /DateDiff(schedule_start,golive,"Day") the calculation shows 0. If I use multiply, plus, or minus instead of divide the calculation works.

The result should be .77 which is showing as 0.00 when I use divide.

Any suggestions?

Thanks,
Liz

Outcomes