topic Re: Inputlookup cannot perform stats function on field in Reporting

Inputlookup cannot perform stats function on field

POR160893 — Wed, 06 Jul 2022 11:58:15 GMT

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,

Re: Inputlookup cannot perform stats function on field

ITWhisperer — Wed, 06 Jul 2022 12:04:45 GMT

Put column names with embedded spaces in single quotes

| stats values('Migration Comments')

Re: Inputlookup cannot perform stats function on field

POR160893 — Wed, 06 Jul 2022 12:09:38 GMT

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

Re: Inputlookup cannot perform stats function on field

ITWhisperer — Wed, 06 Jul 2022 12:20:24 GMT

Does your field name have trailing blanks, perhaps?

| stats values(Migration*)

Re: Inputlookup cannot perform stats function on field

gcusello — Wed, 06 Jul 2022 12:21:57 GMT

Hi @POR160893,

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

| stats BY "Migration Comments"

Ciao.

Giuseppe