Solved: Select Query on Column Type Number - Page 2

MauriceWhelan · 07-15-2019 07:37 AM

I am using a Select Function to retrieve an initail value in my form, however, I want the field to remain as a Number type. I am getting an error unless I change the field type. Is there anything I can add to the expression to allow me to use the Select Function and maintain the field type as Number?

Thanks.

Steve

The problem is that SELECT() produces a List result, but the column value should be a singular value. To fix, either wrap SELECT() in ANY():

ANY(
  SELECT(
    Product_Master_File[Length (m)],
    ([Product Code] = [_THISROW].[Product Code])
  )
)

Or replace SELECT() with LOOKUP():

LOOKUP(
  [_THISROW].[Product Code],
  "Product_Master_File",
  "Product Code",
  "Length (m)"
)

Both are equivalent.

View solution in original post