The input function doesn't seem to work with a numeric list?

I have a numeric list that I want to use as an input to a reference action using the INPUT function but I get an error when trying to use it to SUM the values. I get an error that says the SUM function is expecting a numeric list.

Action “Update Best Nets Row 2”: SUM(TOP([_INPUT].[Team_Nets], [Game].[Number of Best Nets]))

My quick test shows the same result. I suppose the system fails to check the type of the elements in this list.

I guess you have to pass the result of a pre-calculated SUM value…

Thanks for confirming this. I sent in a Bug report to support.

You can’t use INPUT within another expression.

3 Likes