select has invalid input

[akhilb77]

can any one help me know what is the error in this statement

[Steve]

Read the doc: SELECT()

[akhilb77]

Hi steve

i have gone thru the documentation on select() statement.

but still I am unable to understand what is the invalid input in my select statement 

[Parki]

Hi,

I believe the first parameter to select needs to be in the form  dataset-name[column-name], so it should be QUOTE DETAILS[QTable_ID].

[akhilb77]

Dear,

I am writing this formula in the auto compute column of one of the columns name ItemSNo in Quote Details Data table only. so According to me Tablename is not required.

Still I tried with table name also . It is showing me the same error . 
Thanx for your support but please help me in resolving the issue if u can

[Parki]

Hi, not sure what the issue is with the select. My only suggestion would be to try using a filter() statement instead.

[Arni_Kli]

I think the table name is mandatory. It seems to me that the error is caused by the fact that FALSE (presence of duplicates) is specified for the key column with unique values, where there cannot be duplicates.

COUNT(SELECT(Table[QTable_id], TRUE))