An argument of function 'SQRT' has the wrong data type or the result is too large or too small.

[Anonymous]

When i run 

sig. = IF([means(current)]>[means(last)], IF([t score]>[t-value],1,0))

the error pop up that An argument of function 'SQRT' has the wrong data type or the result is too large or too small.

But if i calculate t-score and t-value in separate measures, it can return the value properly, do anyone know how to solve this?

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

An error message like the following appears, probably because the created formula returned the wrong field type. Just check it out.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Your outer IF function is missing the "else" path.  This will result in BLANK() which will trip up the SQRT().