Checks to see if the value is a number. If the value is a number it will just return that value. If the value isn't a number the alternative value will be returned.
IfNonNumber([Primary Value], [Alternative Value])
Where:
Primary Value is the value to check for if it is a number.
Alternative Value is the value to return if the Primary value is not a number.
Rule | Result | Meaning |
---|---|---|
SppIfNonNumber("T27",0) | 0 | Will return the Alternative value as the Primary value is not a number. |