Table Calculation "Unknown constant for .."

Knowledge Drop

Last tested: Sep 21, 2020
 

The Problem

For table calculations with if statements, the error unknown constant will be produced if the user uses a comparison to a decimal without a leading integer.

A Solution

Add a 0 before decimal place.

This example will fail with the error: "Unknown constant for .25"
if(${stuff}<.25,"0 to 25","25 to 75")

To fix it, add a leading zero:
if(${stuff}<0.25,"0 to 25","25 to 75")

Pictures

This is what the error looks like:

Screen Shot 2019-09-03 at 5.02.27 PM.png

This is the table calculation, fixed:

Screen Shot 2019-09-03 at 5.02.37 PM.png


 

This content is subject to limited support.                

Version history
Last update:
‎06-14-2021 05:55 PM
Updated by: