calculated fields in views

[prettitoni]

In my view, I'd like to do a subtraction on two fields, but both values can contain nulls. When one field has a value and the other is null, the calculation returns null. Can someone show me how to do this so it adds the value that's not null to the null one and get an actual value?

 

[dbomrrsm]

look at ISNULL in Book Online

it really depends what you want the null to be in the instances it occurs - if you want it to be 0 you can use isnull to make sure it is.

[blue]DBomrrsm[/blue]