I have this calculation in which I have to reverse a negative number. I am
trying this syntax to no avail. Can someone give me an alternative or do I
have to CASE out all my subtotal buckets???

Any help is greatly appreciated.

Thanks!

    ISNULL(DERIVE7.total,0) +
    ISNULL(DERIVE8.total,0) +
    CASE WHEN DERIVE9.total IS NOT NULL
        THEN    (DERIVE9.total * -1)
        ELSE    0                'Net Lender Fees'




wnfisba

Stored procedure to change not nulls to nulls
To write SPs, or not to write SPs, that is the question....
Client app doesn't work now!
Optimize query with many NOT IN
problems with this SP