Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Commas in Formulas

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release. 

Question

I have a modeled account with this code: ACCT.Personnel.Salary. I want to filter by the Position dimension in a Custom account, so the formula would look something like this: ACCT.Personnel.Salary[Position= RN, Triage]. I am using the formula assistant, but I keep getting a syntax error. How can I get this formula to work?

Answer

The issue is most likely with the comma in the dimension value name. Here are a few things that you could try:

  1. In the Define Dimensions screen, change the dimension value name so that it does not contain a comma. When you update a dimension value name, it will update in all formulas where it is referred to.
  2. You could try using a backslash to escape the comma in the syntax: ACCT.Personnel.Salary[Position=RN,\ Triage] If you modify the formula, this will have to be re-added because it disappears after you save the formula.

This problem does not occur in the modeled sheets because the syntax is slightly different there.

We recommend solution #1. In general, users should try to avoid using commas/semicolons in dimension value names, but the system will not prevent the entry.