Error in calc column for MEDIAN

[vmakhija]

Hello

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?

[Stachu]

I'm not 100% sure, but I think that you need to change the data type of Column1 from Any to Number

[vmakhija]

@Stachu

Column1 is already of datatype "Whole Number"

[Stachu]

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?

[vmakhija]

@Stachu

Yup, both are "Whole Number". See below -

There are no non-numeric values in this column. My earlier screenshot shows all the values available for this column.

[Stachu · Accepted solution]

hmm, for even number of items median can be decimal number even if it's based on Whole numbers.
can you try switching data type to Decimal with format as Whole?

[vmakhija]

@Stachu, that helped 🙂

Now I think of it, it was so silly one to not think of.