Advanced Formatting Issue with Expense Accounts in FCCS Income Statement
In the Income Statement, expenses are expected to display as negative values. So I have applied advanced formatting to show brackets for account type as an Expense. However, when an expense account has a negative balance, the advanced formatting is not working as expected, instead of showing as positive, the close bracket is still appearing which is incorrect. How can I configure advanced formatting in FCCS so that expense accounts display with proper brackets and the sign logic works consistently? I don’t want to manually fix expense and income accounts separately.
Has anyone else encountered this issue with advanced formatting in the Income Statement? Expectation: Ideally, the conditional formatting should apply the correct sign logic without manual intervention on the basis of account type. Has anyone resolved this or found a workaround? I have faced this issue in every project.