How to use a calculated field in a SUM function? (Statistics)
Hello! Please someone help me with this error! 😥
I am creating a table (card) with the mean, variance and standar error of a data column named "Score".
The mean is calculated like this and the value is 6.67:
If I calculate the variance using the value of the mean it works:
That's not the idea cause the mean can change, but if I try to use the mean calculated field I get this error:
I tried it on Excel and it does work. I tried creating a constant column with the mean drectly on the ETL but is not possible. I guess the error has something to do with the SUM function. Help!😥