Inputlookup cannot perform stats function on field

[POR160893]

Hey,

I have an inputlookup and I need to perform a stats values on one of the columns "Migration Comments". So, I am able to use the stats functions on every column EXCEPT the one column I actually need to perform the function on. It seems recognises the field name, even though I am copying the name of the field into the query.

Here is the data table:

And here is what the query I am trying to run looks like?

What am I doing wrong???


Many thanks,

[gcusello]

Hi @POR160893,

never use spaces in field names, if you must have spaces, use quotes:

| stats BY "Migration Comments"

Ciao.

Giuseppe

[ITWhisperer]

Put column names with embedded spaces in single quotes

| stats values('Migration Comments')

[POR160893]

It is really strange as I am able to access other columns like this:

[ITWhisperer · Accepted solution]

Does your field name have trailing blanks, perhaps?

| stats values(Migration*)