Help with a very simple expression

[hubyh]

Hello all, I'm trying to build an expression that will find a value <26 in a single row, this will only occur once once in my current build, then add that number to a new column.  Sure this is very simple but I am still new to this. 😁

[binuacs]

@hubyh something like below

[hubyh]

I do want it to look across one row of columns to find the <26 value. I don't want it to look at just one field.

[Qiu]

@hubyh 
For multiple columns, we usually can use the Transpose and Cross Tab tools combination.
Kindly share a sample Input and desired Ouput data, so we can take a closer look.

[Yoshiro_Fujimori]

Hi @hubyh 

I guess you want to add all the numbers less than 26 for each row.

I hope this is what you mean.

(As @Qiu mentioned, it would be easier for us to understand your needs if you attach the input and expected output data.)

Input

RecordId	Col1	Col2	Col3	Col4	Col5
1	20	22	24	26	28
2	29	28	27	26	25
3	40	80	20	10	50

Output

RecordId	Col1	Col2	Col3	Col4	Col5	Sum_Values_LT_26
1	20	22	24	26	28	66
2	29	28	27	26	25	25
3	40	80	20	10	50	30

Workflow