Share
ReportI'm trying to create a consolidated report in Management Reporter and I have it working except for one thing. I have a column set that includes a column for each of the companies being consolidated plus a hidden column for each of the company's intercompany transactions. I then have a visible column that totals the intercompany transactions. The last column is the consolidated column and is a calculation that adds the company columns together and then subtracts the column that has the total amount of intercompany amounts from it. Eveything it working there as expected.
The problem I have is on our Income Statement we have a Gross Profit % row which is calculated by simply dividing the gross profit by the revenue. The problem is in the total intercompany column and the consolidated column, management reporter is (understandable) adding the values in the other columns in that row as opposed to calculating the percentage based on the values in the column. Is there any way around this or at the very least any way to hide the incorrect values in those two columns?
Hopefully I've explained this well enough! Thanks in advance!
*This post is locked for comments
All responses (
Answers (
5
