532920_en-US

liliconcom

Operation Rows

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

 

 

ScriptingWindowsRe: Operation Rows

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);&nbsp;// num_selected&nbsp;is now the number of rows where :OTP is equal to zero&nbsp;

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.)

 

 

Re: Operation Rows

Create new formula column such as

:OTP == 0

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)

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