Reverse the Sign of Tagged Items

You can reverse the sign of a value in CDM XBRL from positive to negative or from negative to positive when you generate the instance document. For example, if your data contains a negative numeric value (for example, for Cost of Sales), you might want to express it as a positive number.

To reverse the sign of tagged items using negation:

1. Open the project that you want to work with.
2. Open and check out the report object that contains a numeric value whose sign you need to reverse from positive to negative, or from negative to positive.
3. Create the tag as usual. The selection in the Pivot Grid must consist of all numeric items. If you select a single element of a drop-down, only that item is negated. If you select multiple cells, all selected items are negated.
4. In the Tag window, select the Negated checkbox.
5. In the Pivot Grid, the number contains a negative sign if the original value in the report object was positive, and a positive sign if the original value in the report object was negative. Additionally, if you open the Tag Inspector tab, you can see information related to negation in the Negated column.
6. Click the report object and save your changes. All tags associated to the item in the Pivot Grid are negated.

   Note: If a tag already exists and the creation of a negated value conflicts with the previous value, the Pivot Grid shows an error that multiple values are specified for a single fact.

7. Check in the report object.

Tip: If you need to apply negation to a fact after it has been tagged, you do not need to open or check out the report object that contains the fact. Right-click the fact in the Pivot Grid, and click Negate Items. In the Pivot Grid, the number contains a negative sign if the original value in the Pivot Grid was positive, and a positive sign if the original value in the Pivot Grid was negative. Additionally, if you open the Tag Inspector tab, you can see information related to negation in the Negated column.