Knowledge Drop

Table Calculation "Unknown constant for .."

  • 15 June 2021
  • 0 replies

Userlevel 5

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")


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.                




0 replies

Be the first to reply!