Hello,

I'm writing an employee position roster report.  I need to sum the field {Main_Data.Enc Sal Amt} when {Main_Data.ID} isnull. 

I wrote the following formula:
if isnull({Main_Data.ID}) then sum({Main_Data.Enc Sal Amt})

but it comes up with zero - and I know the amount should not be zero.  I'm thinking I need an else, but I can't figure out what I should put there!

Please help.

Great, thanks!  That worked!