To add or subtract monetary amounts in one account from the monetary amounts in another account, you can use the plus sign (+) and the minus sign (-) in the Link to Financial Dimensionscell.

The following table shows acceptable formats for adding and subtracting links to financial data.

To do this:	Use this format:
Add two fully-qualified accounts	1205-2000-000+1205-2100-000 +Division=[000], Account=[1205], Department=[00] +Division=[100], Account=[1205], Department=[00]
Add two segment values	1205+1210 +Account=[1205]+Account=[1210]
Add segment values that include wildcard characters	120?+11?? +Account=[120?+Account=[11??]
Add a range of fully-qualified accounts	+(1205-1000-000:1205-2000-000) +Division=[000:100], Account=[1205], Department=[00]
Add a range of segment values	+(1200:1205) +Account=[1200:1205]
Add a range of segment values that include wildcard characters	+(120?:130?) +Account=[120?:130?]
Subtract one fully-qualified account from another fully-qualified account	1205-2100-000-(1205-2000-000) +Division=[000], Account=[1205], Department=[00]-Division=[100], Account=[1205], Department=[00]
Subtract one segment value from another segment value	1210-(1205) +Account=[1205]-Account=[1210]
Subtract a segment value that includes a wildcard character from another segment value	1100-(120?) +Account=[1200]-Account=[11??]
Subtract a range of fully-qualified accounts	-(1205-1000-000:1205-2000-000) -Division=[000:100], Account=[1200:1205], Department=[00:01]
Subtract a range of segment values	-(1200:1205) -Account=[1200:1205]
Subtract a range of segment values that include wildcard characters	-(120?:130?) -Account=[120?:130?]

Although you can modify the accounts directly, you can also use the Dimensionsdialogue box to apply the correct formatting to your financial data links. Any of the values can include wildcard characters (? or *). Report Designer cannot select any account, dimension, or field from the Microsoft Dynamics ERP system that includes the following reserved characters: & * [ ].

Note
To subtract values, you must put parentheses around those values. For example, if you enter 450?-(4509), +Account=[4509]-Account=[450?],you are instructing Management Reporter to subtract the amount for account segment 4509 from the amount for any account segment that starts with 450.

Add or subtract accounts from other accounts

In Report Designer, open the row definition to modify.
Double-click a cell in the Link to Financial Dimensionscolumn.
In the first row of the Dimensionsdialogue box, follow these steps:
- In the Operator +/-cell, select the operation ( +or -) that applies to one or more segment values or sets in the row.
- Double-click the cell in the Divisioncolumn. In the Divisiondialogue box, select Individual or range, and then enter a segment value in the Fromcolumn.
Repeat steps 2 and 3 to add more operations.

Note

The operator always applies to the dimensions in the same row.

Add or subtract accounts from other accounts

See Also