Power operator with fractions

I am trying to calculate the compound growth rate that utilizes the power operator with a fraction, for some reason QS always returns 1. If it is not supported is there a workaround?

Check the datatype. CAST-ing integer to float type helps at times

hi @Magda,

We hope Vignesh’s solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking his answer as a “Solution.

kind regards,
Wakana

1 Like