I have this simple column for which I am trying to calcualte a MEDIAN value as below.
But it gives an error saying -- "Expressions that yield variant data-type cannot be used to defined calculated columns"
Any inputs on this?
Solved! Go to Solution.
are you sure it's the data type and not format? they're just next to each other in the UI
unless you changed it in the query editor, then it must be something else - are there any non numeric values in that column?