Skip to Content
0
Former Member
May 25, 2009 at 11:33 PM

If Else Condition in Query

28 Views

Hi,

I am trying to use the following condition in my Query:

If Planned Hours = 0 ; Over Time = 0

Else OverTime = Actual Hours - Planned Hours.

Please advice on how can I acheive this using the formula in Query.

Thanks

Deepthi