Delete rows with Percentile satisfying this expression
Specify one or more filtering expressions to filter by PCTL value. The PCTL value is specified in the Percentile to Compute for PCTL Statistic parameter. Use the keyword PCTL.
Valid expressions include:
• | PCTL GT xx (Greater Than) |
• | PCTL LT xx (Less Than) |
• | PCTL EQ xx (Equal to) |
where xx is an integer that you specify.
Important: Do not use double quotation marks.
Example: To delete rows in which the 80th percentile of all values in that row exceeds 10, specify PCTL GT 10 in this field, and specify 80 for the Percentile to Compute for PCTL Statistic field.
To Specify Rows to Delete:
8 | Specify an option other than none for the Delete rows: parameter. |
8 | Type a valid expression into the text field. |
8 | If you change your mind and would like to reset the field, click . |