Management reporter help?

(0) Share

Report

Posted on by deanne917

2,035

Hello
We currently have an Frx report which we're converting to MR.

The report has expenses going down each row with 8 columns going across

Looks like this:

Expense                                      Dept 1              Dept 2              Dept 3                     Total Company
                                               Actual Budget Actual Budget Actual   Budget       Actual             Budget
Salary                                      500       600          600   900         700       300              1800           1800
Supplies                                   250      100          100   300         300       500                650             900
Miscellaneous                            50       100           20      10          10         80                  80              180
---------------------------    ---------    ---------      ------ ------      ---------   -------            --------         ---------
Total Expense                           800        800         720       910         1010      880                 2530            2880
Percent of Total                     31.6%     27.8%      28.5%   31.6%      39.9%     40.6%

A B C D E F G H

The percentage formulas are: A/G B/H C/G D/H E/G F/H

How do I put these percentage formulas into MR?

*This post is locked for comments

All responses (9)

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: Management reporter help?

Leah / Deanne -

I tested this formula format this afternoon and it works. I am fairly certain omitting the '.' in the formula caused your issue. Do let us know if this resolved your issue :)
Leahs on at

Like (0)

Report

RE: Management reporter help?

It looks like you were able to narrow in on the formatting issue and it looks like the next steps is to try the following in the Management Reporter Row Definition CAL entry.

C,E,G,J=@840/J.840, D,F,H,K=@840/K.840

Let us know how it goes.
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: Management reporter help?

I believe the exact syntax of c.840/j.840 is necessary.
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: Management reporter help?

Yes, in a CAL line in your Row Definition.
deanne917 2,035 on at

Like (0)

Report

RE: Management reporter help?

C,E,G,J=@840/J840, D,F,H,K=@840/K840

In Management Reporter, this formula is not accepted
deanne917 2,035 on at

Like (0)

Report

RE: Management reporter help?

Also, is it an if/then/else type of formula?
deanne917 2,035 on at

Like (0)

Report

RE: Management reporter help?

I see what you did - however, where do I put those formulas? I'm assuming in the line on the row format. Is that right?
Suggested answer

Redbeard 12,931 on at

Like (1)

Report

RE: Management reporter help?

Deanne -- Hopefully the image above makes sense. I added in row numbers and heading letters (corresponding to your columns) then put in the equations you would need to produce the results you want.

deanne917 2,035 on at

Like (0)

Report

RE: Management reporter help?

The formulas didn't come over aligned. It's the department / total company amounts