Usefulness of domain completion

Domain completion can be useful in many circumstances. In fact, you may have gleaned some uses from the previous exercises even though they were designed merely for illustration purposes. The following exercise demonstrates using domain completion to display No Data for cells without a value in a sparsely-populated view.

Exercise: labelling nulls

Let us look at the following steps to begin with the exercise:

1. Duplicate the worksheet from the previous exercise, DC – View Types. Name the new worksheet DC – Labelling Nulls.
2. Adjust the duplicated worksheet so that the view type is set to Text. Also insure that only Title and Year are deployed on the view. Be sure to leave Title on...