i have rows in a field that are causing me a problem and I think its because its set to numeric and some of the rows are blank.
would this put a value into the field for me if im using a derived box
ISNULL([Fixed Rate]) ? "0.00" : [Fixed Rate]
it just doesn't seem to put the 0.00 into the field