Announcements
No record found.
Hi,
In Management Reporter, sign behavior in calculated columns (like variances) is influenced by both the normal balance of the accounts and the calculation logic used in the column definitions. Here's how you can approach the issue:
Use Row Modifiers for Expenses: For expense accounts, you can apply a row modifier such as Flip or Normal Balance to reverse the sign only for those rows. This allows you to maintain correct signs for revenue and expense accounts independently.
Flip
Normal Balance
Column Calculation Logic: If your formula is H - C and both values are negative (e.g., -628 and -7500), the result will naturally be negative. To reverse this only for expenses, consider using conditional logic in the row definitions or separate columns for revenue and expense variances.
H - C
Reporting Tree Overrides: If you're using a reporting tree, you can apply overrides at the unit level to control sign behavior for specific departments or account categories.
Account Categories: Group expense accounts separately and apply sign logic only to those rows. This avoids affecting revenue or other account types.
Custom Formatting: Use formatting options in the report definition to display signs differently based on account type. This won't change the math but can help with presentation.
In summary, the best approach is to apply row-level sign control using modifiers or account category logic, rather than changing the column formula globally.
Please verify if this helps clarify your reporting setup.
Thanks and best regards, Daniele Note: This response was prepared with support from Copilot to ensure clarity and completeness.
I think what’s throwing everything off is that MR keeps applying the natural debit or credit behaviour of the row even when the variance math itself is technically right, so the calculation ends up looking backwards for expense accounts. Revenue lines usually behave fine because the normal balance direction already matches the report logic, but expenses tend to flip the visual result once you start mixing H minus B style formulas in the same column. I was reading through some finance workflow examples on https://mysupergeek.co/finance-assignment-help-service and they actually explain pretty well how financial reporting systems handle variance logic differently depending on account classification and balance type, which sounds very close to the issue you’re dealing with here. Honestly I’d avoid changing the whole column formula and instead try a separate calc row or conditional formatting specifically for expense sections because MR can get stubborn once natural balances start overriding presentation logic. It feels less like your math is wrong and more like the reporting engine is forcing accounting behaviour onto the display layer.
The issue occurs because Revenues and Expenses have opposite normal balances, so the same column formula produces opposite signs for each. Since changing the column formula would flip all signs, the fix should be applied at the Row Definition level in D365 Financial Reporter. For your Expenditure rows, set the Normal Balance field to "D" (Debit) in the row definition — this tells the report engine to automatically reverse the sign for those rows only, showing the expense variance as a positive 6,872 without affecting the revenue variance of (534,127).
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 591
André Arnaud de Cal... 550 Super User 2026 Season 1
Abhilash Warrier 543 Super User 2026 Season 1
