Error - the result of a formula can't be an array

[kgrubby]

I am trying to create a formula to list out the values entered into the parameter.

The formula is:
"Average for " + {?CLIENT ID} + "(" + {CLIENT.COMPANY_NAME}
+ ")"

Since there is multiple parameters, how do I get it to return every parameter that was entered?

 

[synapsevampire]

This is saying that the {?CLIENT ID} parameter is a Alow Multiple Values type, which means that it doesn't know which one you wish to display.

Why not use the {client_id} from your table instead of the parameter?

If you need to reference the parameter, use a subscript as in:

{?CLIENT ID}[1]

-k

 

[kgrubby]

If I just put the field instead of the parameter, it only returns the first client ID in the list. I want to list all the Client ID's that were inserted with the parameter.

 

[synapsevampire]

Ahh, OK, use:

"Average for " + join({?CLIENT ID},", ")+ "(" + {CLIENT.COMPANY_NAME}
+ ")"

-k