Syntax Error: Check Spacing

If you're receiving a syntax error when using metrics or custom values in your equations, check to make sure that the elements of your formula or case statement are properly spaced. WHEN, THEN, and ELSE elements must have spaces between them and other elements.

In the example below, a space is missing between WHEN and the metric Budget Amount. Adding a space between WHEN and Budget Amount in the clauses below will solve the syntax error.

Syntax Error: Percent Format

When using percentages, they need to be written out in decimal form instead of X%. For example, instead of adding 15% in your formula, use 0.15 instead.

NOTE: It is important to include the 0 (or another number if using a percentage greater than 100%) before the decimal point or else the formula will fail. 

Syntax Error: Percent Format

When using percentages, they need to be written out in decimal form instead of X%. For example, instead of adding 15% in your formula, use 0.15 instead.

NOTE: It is important to include the 0 (or another number if using a percentage greater than 100%) before the decimal point or else the formula will fail. 

 

Decision Grid Display Error: Data Doesn't Display Even Though Formula is Correct

There are times that you may create a dynamic custom value successfully, but no data displays in the Decision Grid. 

In this case, check to make sure that the data format in the Custom Value form matches the type of data output by your formula. 

For example: If you create a Custom Value that outputs a text result, but you set the data format as a number, the Decision Grid will not display any data for your Custom Value