How can i fix this error please help.
[Pair QTY] * ANY(SELECT(AutoSelect[TIME DURATION], ([CHANNEL] = [Channel Selection])))
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.
[Pair QTY] * ANY(SELECT(AutoSelect[TIME DURATION], ([CHANNEL] = [_THISROW].[Channel Selection])))
Add the [_THISROW] before [Channel Selection]
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
16 |