Global Precision-Based Overrides

A summary of the number rounding and scaling feature in Wdesk, also referred to as a global precision-based override.

Modifying a Linked Number

You can modify a linked number (and a formula cell) in a document at a certain precision. This is useful if you need to adjust how a number in a table is rounded in order to have the table foot correctly.

Overrides can be added or adjusted by selecting the source link of the value needing adjustment, selecting the File tab, the Properties button, choosing Link Properties, and manipulating the precision and adjusted value fields. Selecting the Add button from the Global Precision-Based Overrides section of the Link Properties panel will allow you to add new overrides for the selected number.

Creating a New Override

  1. To create a new override, select the source link of a value you wish to adjust. Then open up the Link ´╗┐Properties panel to access the override controls (File > Properties > Link Properties).

    image alt text

  2. To get started, go to the Overrides tab in the Link Properties panel and click the green plus button.

    image alt text

  3. A series of controls will be displayed, the first is a drop-down to select the precision at which you want to modify. For example, if the usage link that you want to adjust has a Shown In of thousands and a Decimal Digits of 1, you would select -2 from the drop-down (1 - 3). The precision you want is always equal to Decimal Digits minus Shown In for the location at which you want to adjust. You can then use the up and down arrows on the adjustment control until you have the new value you want. This number is displayed in ones for the purposes of the control, but will be used in the Entered In and Shown In that are on the cell.

    image alt text

  4. Once you click the green checkmark, the value will appear in the grid below. These are all the overrides that you have assigned to this source cell. A source cell can have multiple adjustments for the different precisions linked throughout your document(s).

    image alt text

  5. To change a value, click the pencil icon on the row of the override you wish to edit and select a new value. To delete a value, click the orange X delete button on the row of the override you wish to delete. If the value of the source cell changes, the override will no longer be applied, which is displayed with a yellow indicator. Overrides that aren't being applied are identified in validation.

    image alt text