Forum Discussion
Borjaveigasvh
6 years agoRegular Visitor
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...
- 6 years ago
You can abuse the logical true as a number.
Calculated column= sum(column1>blank + column2 >blank + ...)
Might need additional encapsulation.
lbendlin
6 years agoSuper User
You can abuse the logical true as a number.
Calculated column= sum(column1>blank + column2 >blank + ...)
Might need additional encapsulation.
Borjaveigasvh
6 years agoRegular Visitor
True! Thanks I din't see it that way.
Many thanks
Borja