Thank you, like you said I don't need AVG. It makes sense

You are right, So I have tried to filter out the negative values and calculate the geometric mean but now It's giving me the same output everywhere. EXP(AVG( CASE WHEN @calculation("LOS") > 0 AND @calculation("LOS") IS NOT NULL THEN LOG(@calculation("LOS")) ELSE NULL END)) How can I adjust this do calculate for row by row…

The logic is to calculate the geometric mean of LOS field

Im just trying to replicate the calculation logic I tried to round off the values, used case when to check if the value in "Exp(value)" is < something. But nothing worked for me

That worked perfectly Thank you!