Forum Discussion

loganwol's avatar
loganwol
Microsoft Employee
10 years ago
Solved

How to check for Infinity value

Hi,   I have a table with two columns that represent Upper and Lower Limits for measurement values of a system. The limit values can be valid integer values, Blank or (+/-)Infinity. I want to check...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    I think infinite values will read as errors, so ISERROR(TableName[ColumnName]) should do it. Otherwise you could try NOT(ISNUMBER(TableName[ColumnName]))