I have a field that determines what the best time to call a client is. Because we have had clients longer than this database, I haven't filled in all of the "Best Time To Reach" fields.

The calc field that reads the BTTR field uses an Evaluate to update whenever the BTTR changes. The issue I have fallen upon, is that if BTTR is empty, it will not give me any value.

For now, I got around this by using an If(isempty; 1 ; Evaluate (rest of calc))

Is this an expected behavior?

If my question isn't clear, I'll post the calc. It's large, and not very readable though. ;-)

Thanks

The first thing I would try is to edit the calculated field definition and uncheck the check box labeled "Do not evaluate if all referenced fields are empty."