Using Case when a calculation gives a question mark
I've been reading up about Case, and thinking it was what I needed, found a problem.
I have a calculation (CalcField = Field 1 / Field 2). When Field 1 has no data in it, CalcField comes up with a "?". When there is data in Field 1, there is no problem in presenting a result (3, 44 etc).
'Case' seems to work if you know what the answer is, but I don't know.
I've looked at previous questions and haven't been able to work out how they would apply to me.
This is probably simple, and I will probably understand it when someone points it out!