Home : SQRT function does not calculate correctly when cascade MDL rule is checked
Q12881 - KNOWNISSUE: SQRT function does not calculate correctly when cascade MDL rule is checked

There is a known issue when using the SQRT Function in a variable equation if the cascade MDL rule is also checked.  The function is intended to report the square root of a number, however, in this case it returns the number itself, not the square root.

Symptoms: 

Solution:

Instead of using SQRT(V4725) use SQRT(V4725+0)

If you use SQRT(C4725+0) and Variable 4725 is blank then 0 will be returned.

 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 2/16/2010 11:49 AM.
Last Modified on 2/16/2010 5:05 PM.
Last Modified by No Author Name Available!.
Article has been viewed 3224 times.
Rated 8 out of 10 based on 2 votes.
Print Article
Email Article