How to Blank or Cap R Table Cells

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 the object inspector > General > General > Name.

3. Select Calculation > Custom Code from the toolbar.

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

5. In the R Code editor, add a line to the code that defines the table as table = table_name where table_name is copied from step 2.

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

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

8. OPTIONAL: Select this output and go to Appearance > Appearance to adjust decimal places, formatting, etc.