The problem is, my $(MetricSyntaxList) variable is now 5,200+ characters, and no longer works. I know my syntax is correct, because it works if it's under 5,200 characters and breaks if it's over 5,200 characters.
I don't think there is supposed to be a limit. That said, I believe I've run into expression length limits before when specifically trying to test that. When long enough, I've had valid expressions crash out the entire application.
Unfortunately, I don't know of a good workaround for what you seem to be trying to do.
Maybe if you need this in a chart type that allows hidden expressions, you could check for a limited number of metrics in several different pick(match()) expressions. Then create a final expression that picks the first non-null value from the previous results. That's assuming the limit is related to one expression or variable, and not to the total across several. Since the limit is likely a bug, it's very hard to guess what might and might not work.
Hi Corey, I had the same problem in a big customer with big complex expression in version 8.5, unfortunately we could not find a good way the solve it, but to migrate to version 9. I guess you can have a good chance using hidden expressions as John pointed out.
This is a rather old topic, but I suspect you can autocomment expressions by adding variables.
First set variable, name it vCommentEnabled and set definition to:
Then add a text object to the sheet with expression:
='test 1 ' & $(=$(vCommentEnabled(0))) 'test2'
And add another text object to the sheet with expression:
='test 1 ' & $(=$(vCommentEnabled(1))) 'test2'
You'll notice that based on the parameter 1/0 the latter of the expression is automatically commented out. That is, the 'test2' bit of the expression can be dynamically commented, depending on the output of the variable vCommentEnabled acting as a user defined function.