Skip to main content
Question

Formula Number Duration

  • Jan 11, 2019 2:02 AM UTC
  • 0 replies
  • 48 views

Forum|alt.badge.img+12
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])
This topic has been closed for replies.

Forum|alt.badge.img+12
  • Author
  • Qrew Commander
  • Jan 14, 2019 8:00 AM UTC
I figured out the problem.  Some of the other duration fields were causing the problem because I was not using NZ.