How to calculate the length of row with specific value in a specific column

Questions about Thunkable
1

Hello Brother,
First take a look at the photo. I want to calculate the length of row containing value 1 in column ‘clm’ (red marked) and also containing value 2.

Could you please help me?

newpb
newpb728×387 53.3 KB

2

Hi, @farhadkubd1! :wave:

Do you want to calculate the length of the whole Column “clm”?

Thanks! :blush:

3

Hello,

What are your difficulties? Can you get all the values from the selected Column? After that, distribute them across the list and use the sum block over the list entries.

4

whole column ‘clm’ but with individual value such on how many rows the ‘clm’ column contains value 1? please view the next photo. i have calculate it succesfully. but now i want to calculate with reference value 1 & 2 in column ‘clm’.

example

5

my difficulties is i cannot calculate the length of rows at ‘clm’ column. such as how many rows contains the value 1 at ‘clm’ column? and so for value 2.

6

You need to create a loop over all rows and in this loop do a check, if the cell value is 1, then add it to counter1. If the cell value is 2, then add it to counter2.

1 Like