Last Modified Date: 27 Oct 2016
ResolutionCreate a calculated field for odd values.
- Select Analysis > Create Calculated Field
- In the Create Calculated Field dialog box, do the following and click OK:
- Name the field. In the example, this field is called "Odd values" and enter the following formula:
IF [Val] >= 0 THEN POWER([Val],1/n) ELSE -POWER(abs([Val]), 1/n) END
- Define the n by the root of negative number. For example:
IF [Val] >= 0 THEN POWER([Val],1/3) ELSE -POWER(abs([Val]), 1/3) END
Additional InformationFor the even values of n, the result of the following calculated field is correct POWER([Value],1/n), for example: POWER(-2,1/2) = NULL.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials