FAQ: How Can I Remove the Effects or Consolidation Percentages from Specific Accounts
When you add consolidation percents to levels, the percent applies to all values for general ledger and custom accounts at the level.
To remove the effects of consolidation percentages:
- Use metric accounts, which ignore consolidation percentages by design.
- Use a formula on the (Only) level of the parent account to readjust the value.Example: The consolidation percentage for the Company A level is 50%. You don't want the Expenses account to adjust with the consolidation percent. Add this shared formula to the Company A (Only) level: =ACCT.Expense[level=LowerLevelName]*0.5 .