Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

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?
Need Help
Show and Tell
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    3 years ago

    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.

     

     

     

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

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

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    3 years ago

    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.