New to this forum so thanks in advance for your patience. In Management Reporter I'm trying to create some simple ratios based on P&L line items. My row definition for the ratio calculation isn't calculating correctly. Below is a screen shot of my row definition. Any thoughts as to what I'm doing wrong?
*This post is locked for comments
I have no clue why but I added a blank row between the payroll line and the calculation to accurately mimic yours, and it worked!! Not sure why, but I appreciate all your help.
I set up a test report and I'm getting 66.67% every way I try and run it. Can you take a screenshot of your Column layout and Settings tab from the report definition?
Here's what mine looks like:
Tried changing the calculation priority as well with no results. It's a pretty simple report. Gross profit and payroll totals and then trying to calculate a ratio of one against the other. In simple illustration, if GP was 3 and payroll was 2, then my payroll to GP % should be 67%, but it's coming up 100% every time.
I'm not sure what other things are going on in the Column but you could try switching your calculation priority found on the Settings tab of the Report Definition. If it's set to column first, switch it to row first or vice versa. However, depending on what you have going on in the column format, this could potentially make other calculations not correct.
When you say the calculation is not correct, what specifically are you seeing?
Tried that. Didn't work.
You need an @ symbol in front of each number when doing a CAL. So @250/@220.
Hopefully it loads this time.
The screenshot didn't come through, can you try uploading it again?
#1
André Arnaud de Cal...
291,602
Super User 2024 Season 2
#2
Martin Dráb
230,338
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
