If Else statement in a expression

[tsoley9262]

I currently have a statement that works

([Completed Count]+[Management Host]) / ([Grand Total])

I am trying to add

If([Completed_Date]> ' ' ,([Completed Count]+[Management Host]+ {Roadblock_Count) / ([Grand Total]) elseif ([Completed Count]+[Management Host]) / ([Grand Total])

Thanks for your help!!

[wandererroch · Accepted solution]

The syntax is if(Expression, True expression, false expression)
so yours would be something like
If([Completed_Date] = ' ' ,
([Completed Count]+[Management Host]+ {Roadblock_Count) / ([Grand Total]) , //True
([Completed Count]+[Management Host]) / ([Grand Total]) //False
)

[tsoley9262]

Thanks that worked great!!