This content has been marked as final.
Show 3 replies

1. Re: calculation field stores Question mark
beverly May 23, 2016 2:51 AM (in response to sudha)If there is an ERROR or the length of the number if too long, you will get the "?"
Can you test in the Data Viewer to see what the error might be?
Or can you resize the field (wider) to see if that's the problem?
IF you divide by "0" that is an error.
You can test for possible problems and return 0, for example:
X = If ( B = 0 ; 0 ; A/B // test for 0 )
beverly

2. Re: calculation field stores Question mark
erolst May 23, 2016 2:54 AM (in response to sudha)Division by zero is mathematically not defined.
So you should trap the case where the divisor can be 0.

3. Re: calculation field stores Question mark
sudha May 25, 2016 4:15 AM (in response to beverly)Thanks beverly.