AnsweredAssumed Answered

Returning Zero on Calculated Average Days

Question asked by LASLF on Apr 15, 2013
Latest reply on Apr 15, 2013 by LASLF

Title

Returning Zero on Calculated Average Days

Post

     I have a formula to calculate average turn around (in calendar days) for projects in my database:

     (Sum (Days to Complete)/Count (Days to Complete))

     There are instances where projects are completed the same day they're started.  Is there a way to modify this formula to return a value of zero if the result is less than 1?

     The formula to get "Days to Complete" is:

     If (${Tridion Publish (Live)}  ≤ 0;  "" ; (${Tridion Publish (Live)} - Date Rec'd) )

     Thanks in advance for your guidance.

Outcomes