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.

Error: 

Correct: 

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. 

Error: 

Correct:

 

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

Error:

Correct:

 

Case Statements: Sequential Evaluation Errors

When using dynamic custom values and case statements, it's important that you set up your formula so it executes sequentially.

For example, let's say you want to calculate management fees for various levels of spend. At various levels of spend, a customer is charged a certain % or amount management fee) applied.

To set up the formula correctly, you'll either want to set upper and lower bounds within your formula or make sure data is evaluated sequentially (if you're using operators such as >, <, <=, or >=).

Error:

This case statement above will not evaluate correctly. The statement "WHEN Budget Amount >=1000 THEN 0.075" should be first sequentially because you are using the >= sign. Budgets Amounts greater than >1000 should be evaluated first, followed by >=500, >=100, and then all others.

Correct (Listed in Sequential Order):

OR: 

Correct (Upper and Lower Bounds):