How to Blank or Cap R Table Cells

Oliver Harrison

This article describes how to go from a table with all cells being displayed...

...to one where any cell under a specified threshold has been removed or changed.

Requirements

1. Select your table.

2. Copy the name from Properties > GENERAL > Name.

3. Select Calculation > Custom Code.

4. Click onto the page to place the custom calculation.

5. In the object inspector go to Properties > R CODE.

6. Add a line to the code that defines the table as table = table_name where table_name is copied from step 2.

7. Add a line to the code using the table[condition] = value format where value can be an actual value or NA to set the value as missing.

8. Add a line with just the defined table name.

Below is the code from this example that blanks out table cells less than 50:

table = table.Q5.Brand.Image
table[table <50] = NA
table

9. OPTIONAL: Select this output and go to Properties > APPEARANCE > Number format to adjust decimal places.