When creating a Flash Reports function you may encounter an error message indicating that one of the function parameters exceeds the length permitted by Excel. For example, when creating an Account Balance function and including multiple values for the account parameter the account names will be combined into one text value delimited by a comma. If your account names are fairly long you might exceed the permitted Excel length for a text parameter which is 255 characters.
The solution is to simply create the list of accounts in a separate cell and then refer to that cell in your Account Balance function. Below is an example process:
- You create an Account Balance function and see the following error:
- The multiple values in the account parameter have exceeded the Excel limit.
- Rather than including all the accounts in the function itself, create them in a separate cell. Use this functionality to create a special list of values cell in Excel.
- Open the list and select all the account values required. When you click on Ok the values are inserted into the Excel cell, delimited by a comma.
- Reference this cell in your Account Balance function.
