In the Accounts dimension, you can perform subtraction calculations using a member tree. In the fusion_place database, all amounts are stored as debit values. However, when displayed, the debit/credit classification of Accounts is taken into consideration. Therefore, if you want to calculate profit, by setting the Accounts for revenue and expenses, which are the components of profit, as child members of the profit account and appropriately configuring the debit/credit classification for each account, you can calculate profit through an accumulation calculation along the tree. Please refer to the figure below.

⚠ You can also display values as debit-positive or credit-positive, regardless of account attributes.