Hi, I'm having trouble writing an ISNULL function to perform an operation in my report.

I'll try to explain what I'm trying to achieve....

In the report I have 3 columns X, Y & Z
X & Y columns are a Sum of a group.

If X is Null then I want to show value -Y in Z
If Y Is NUll then I want to show value X in Z
If there is a value in both X & Y then Z= X-Y

I can get the 1st part working with

If ISNULL (X) then -Y ELSE X-Y

but I can't get the second isnull check to work.

Can you help?
Many Thanks in advance :-)
Gavin

Worked Perfectly! :-)
I didn't realise you could link multiple Else statements.
I'm such a beginner!!

Thanks for your help.