Multiply Error

[Sirfyaad]

How can i fix this error please help.

[Pair QTY] * ANY(SELECT(AutoSelect[TIME DURATION], ([CHANNEL] = [Channel Selection])))

[JMPeterson]

I am assuming the [Pair QTY] is a Number or Decimal data type? If so, I believe the problem is you are trying to combine mismatched data types. It looks like you're trying to take a numeric value (i.e. 4) and multiply it by a time duration (i.e. 05:14:49 "hh:mm:ss"). Depending on the exact outcome you're looking for you will need to convert the data types to match before performing any math functions.

[scott192]

[Pair QTY] * ANY(SELECT(AutoSelect[TIME DURATION], ([CHANNEL] = [_THISROW].[Channel Selection])))

Add the [_THISROW] before [Channel Selection]