COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: krunal on 29 Nov 2018 01:54:16 AM

Title: cuberoot function
Post by: krunal on 29 Nov 2018 01:54:16 AM
Hi all,

what is the function to find cuberoot in cognos report studio.

Thanks
Title: Re: cuberoot function
Post by: CognosPaul on 29 Nov 2018 11:53:38 AM
There's no root function but finding a root is really just the number to the power of (1 / n). x(1/y). So 81/3 == 2.

Just use power([numeric field],1/3)
Title: Re: cuberoot function
Post by: krunal on 30 Nov 2018 04:56:56 AM

Thanks CognosPaul

it works fine....