AnsweredAssumed Answered

Using Case when a calculation gives a question mark

Question asked by happyez on Mar 3, 2014
Latest reply on Mar 4, 2014 by happyez

Title

Using Case when a calculation gives a question mark

Post

     Hello everyone

      

     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!

      

     Thanks everyone

     Eric

Outcomes