Skip to main content
Question

show a graph for open vs. closed orders . Need help with formula.

  • March 1, 2018
  • 0 replies
  • 26 views
I am trying to show a graph for open vs. closed orders. I currently have the formula correct to show the status is closed. What formula would I use to show the status is open. Right now my graph shows blank instead of open. 

This is the formula that I have so far for closed:

If(not IsNull([Engineering Complete Date]),"Closed",[Status Update])
      This topic has been closed for replies.

      Forum|alt.badge.img+5
      • DebbieTaylor
      • Registered
      • March 1, 2018
      How about 
      If(not IsNull([Engineering Complete Date]),"Closed", if([Status Update]="Closed","Closed","Open))
      Debbie Taylor CloudBase Services
      In case you do you have a field called [Status Update], it would be a date.

      Try this shorter and simple one;

      If(IsNull([Engineering Complete Date]),"Open", "Closed")
      Thank you! The shorter version worked!
      Terms & ConditionsAccessibility statement