View the original community article here
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:
This is the table calculation, fixed:
This content is subject to limited support.