
I am trying to get a percentage ratio across three separate companies on a consolidated financial statement. When I create my TOT rows and my CAL rows the number come out correctly. But when I go to create my percentage row it calculates all of the company percentages separately and then add them together giving me (591.62%) The percentage is suppose to be closer to 54%. Any help with this would be greatly appreciated.
Thanks,
Steve M
*This post is locked for comments
I have the same question (0)If you bring up your Report Definitions and go to the tab on your report that says setting, you can go to:
CALCULATION PRIORITY
Try and change this from
Perform column calculation first and then row
to
perform row calculation and then column
This