Hi all - I am trying to create a calculated metric that uses the POWER function - which, as per the help, "Returns x raised to the y power".
I want to have y be a fraction - specifically, 0.2.
This works OK unless the value of x is negative, when it calculates as "Invalid".
It is valid to calculate fractional powers on negative numbers in general, but it seems like the POWER function isn't happy with this.
Does anyone know any more about this? Or have a suggestion for a workaround?