Operation Rows

[#1]

Hello everyone, I would like to know how to count the number of "OTPs" that are equal to 0 and make the division on the total number of LINES of OTP ? Thank you for your help

NetflixCrow956_0-1660220389778.png

[#2]

Here's how you get the number of rows where OTP is equal to zero (see also here:( 

dt = current data table () << select where (:OTP == 0); // suggest to have only the one table of interest for you open when testing this

num_selected = nrows(dt << get selected rows); // num_selected is now the number of rows where :OTP is equal to zero 

Another way is via point & click:

1. Convert the OTP column to Data Type "Character" under Column Info.
2. Run a distribution analysis of the OTP column. This will show you how many rows with OTP equal to 0 there are.

Can you elaborate a little on the second part of the task, i.e., "...make the division on the total number of LINES of OTP."? I don't understand this. (Sorry.)

[#3 · Accepted solution]

Create new formula column such as

:OTP == 0

jthi_0-1660290585326.png

then use summary to create new table using the new column as Subgroup (remove link to original data table if you don't need it)

jthi_1-1660290595316.png

select N Rows and N(1) columns and create new formula column with right click menu:

jthi_3-1660290716678.png

jthi_4-1660290729283.png