Forum Discussion

Borjaveigasvh's avatar
Borjaveigasvh
Regular Visitor
6 years ago
Solved

Help simplifying conditional column

Good Afternoon,  Maybe someone has a tip for this kind of calculated column. My table has 6 columns with diferent values for each row. not all columns have values, in order to determine how many co...
  • lbendlin's avatar
    6 years ago

    You can abuse the logical true as a number.

     

    Calculated column= sum(column1>blank + column2 >blank + ...)

     

    Might need additional encapsulation.