topic Re: How to formulate the &quot;cube root negative&quot;?? in QlikView https://community.qlik.com/t5/QlikView/How-to-formulate-the-quot-cube-root-negative-quot/m-p/356973#M132496 <HTML><HEAD></HEAD><BODY><P>What if I would like to return an imaginary number? </P></BODY></HTML> Sun, 01 Sep 2013 19:03:23 GMT Anonymous 2013-09-01T19:03:23Z How to formulate the "cube root negative"?? https://community.qlik.com/t5/QlikView/How-to-formulate-the-quot-cube-root-negative-quot/m-p/356971#M132494 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">I have problems in calculating cube roots of negative numbers. For example pow (-27.1 / 3), should give -3, but fails. Any idea why?</SPAN></P></BODY></HTML> Wed, 18 Jul 2012 14:41:10 GMT https://community.qlik.com/t5/QlikView/How-to-formulate-the-quot-cube-root-negative-quot/m-p/356971#M132494 carlos13 2012-07-18T14:41:10Z Re: How to formulate the "cube root negative"?? https://community.qlik.com/t5/QlikView/How-to-formulate-the-quot-cube-root-negative-quot/m-p/356972#M132495 <HTML><HEAD></HEAD><BODY><P>I am not sure about the reason. Since square root would return an imaginary number pow might have restricted the computation. </P><P></P><P>Alternatively you can try, sign(x)*pow(fabs(x),1/3).</P><P></P><P>Kiran.</P></BODY></HTML> Wed, 18 Jul 2012 16:01:39 GMT https://community.qlik.com/t5/QlikView/How-to-formulate-the-quot-cube-root-negative-quot/m-p/356972#M132495 2012-07-18T16:01:39Z Re: How to formulate the "cube root negative"?? https://community.qlik.com/t5/QlikView/How-to-formulate-the-quot-cube-root-negative-quot/m-p/356973#M132496 <HTML><HEAD></HEAD><BODY><P>What if I would like to return an imaginary number? </P></BODY></HTML> Sun, 01 Sep 2013 19:03:23 GMT https://community.qlik.com/t5/QlikView/How-to-formulate-the-quot-cube-root-negative-quot/m-p/356973#M132496 Anonymous 2013-09-01T19:03:23Z