Discussions

Expand all | Collapse all

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

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

    Posted 02-28-2018 21:52
    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])


  • 2.  RE: show a graph for open vs. closed orders . Need help with formula.

    Posted 02-28-2018 22:03
    How about 
    If(not IsNull([Engineering Complete Date]),"Closed", if([Status Update]="Closed","Closed","Open))


  • 3.  RE: show a graph for open vs. closed orders . Need help with formula.

    Posted 03-01-2018 08:20
    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")


  • 4.  RE: show a graph for open vs. closed orders . Need help with formula.

    Posted 03-01-2018 13:02
    Thank you! The shorter version worked!