Formula Number Duration

  • 0
  • 1
  • Question
  • Updated 1 week ago
  • In Progress
I have this formula in a Number formula field.  The Total pending first open is a numeric field because it combines two durations fields together. I can't get this to work.  The formula returns nothing.  What am I doing wrong?

If (IsNull ([Date Closed]),ToDays(Today()-[NWS Date Received])-[Total pending First Open],ToDays([Date Closed]-[NWS Date Received])-[Total pending First Open])
Photo of cowannbell

cowannbell

  • 1,070 Points 1k badge 2x thumb

Posted 2 weeks ago

  • 0
  • 1
Photo of cowannbell

cowannbell

  • 1,070 Points 1k badge 2x thumb
I figured out the problem.  Some of the other duration fields were causing the problem because I was not using NZ.