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?