Which country has the longest postcodes

Longest zip code in the world?

Hello everybody,

is there a possibility in google tables to display all # DIV / 0! to be hidden, i.e. to be replaced by an empty field?

It is not about a NORMAL field with a normal formula (I understand how it works), it is now specifically about fields within a pivot evaluation. In Excel there is the function in the options of the pivot evaluation, in Google Sheets I unfortunately don't find such options.

Here are the instructions for EXCEL, maybe someone knows something similar for google docs?

Hide error values ​​in a PivotTable report

Click the PivotTable report.

On the Options tab, in the PivotTable Options group, click the arrow next to Options, and then click Options.

Click the Layout & Format tab, and then do one or more of the following:

Change how errors are displayed Under Format, select the Show error values ​​as check box. In the field, enter the value that you want to appear in place of errors. If you do not want a value to be displayed in the event of errors, delete all characters in the field.

Change how blank cells are displayed Select the Show blank cells as check box. In the box, type the value that you want to appear in blank cells. If you do not want a value to be displayed, delete all characters in the field. To show zeros, clear the check box.