Forum Discussion

SkylarTrivieri's avatar
SkylarTrivieri
Qrew Trainee
8 years ago

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

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])
  • DebbieTaylor's avatar
    DebbieTaylor
    Qrew Trainee
    8 years ago
    How about 
    If(not IsNull([Engineering Complete Date]),"Closed", if([Status Update]="Closed","Closed","Open))
  • EstherGrandal_D's avatar
    EstherGrandal_D
    Qrew Cadet
    8 years ago
    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")