I am having trouble with an iif in SQL and was wondering if someone could help me with the syntax.
here is one line of my query.
Round(((sum(ORIG_BAL) -Sum(wo_amount)) / sum(ORIG_BAL)) * 100,0) as SalvageCollected
What I would like is to display a zero if the value is null or a zero but I keep getting errors in syntax, I know that this is possible I am just getting lost in my braces.
Thanks
Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]