[Kathy Kim]

Is it possible to add a row in MR that does the following:

Picks up the amount in accounts 0-110-6010-000 to 0-110-6080-999 (easy part)
Plus (0-500-6010-000 to 0-500-6080-999)*.25

I’m sure this is easy, but I can only figure out how to add the two accounts in full or add together and then do a calculation.  

I can change the way the 500 accounts are entered if need be (make them fixed allocations), but would prefer not to do so because we are presenting at 100% in another report.

Adding a tag for because I know that he will know.  I’m thinking I need to do the above on 2 separate hidden rows and then add the rows together?  Am I on the right track?

——————————
Kathy Kim
Director of Finance
Donor Network of Arizona
Tempe AZ
——————————
?

[Steve Erbach]

,

You flatter me. I’ve been away from MR ever since I moved to my new job three years ago.

One thing I would ask: is there the same number of accounts between 0-500-6010-000 and 0-500-6080-999 as there are between 0-110-6010-000 and 0-110-6080-999? What you’re looking for is similar to a SUMPRODUCT in Excel, yes?

Someone who has a better grasp of this is or of MSX Group, for sure.

Sincerely,???

——————————
“Sparkly” Steve Erbach – Green Bay, WI
Co-Chair, GPUG WI (Green Bay) Chapter
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach

—————
Excel Webinar List as of June 10, 2020
——————————
——————————————-

[Kathy Kim]

Sparkly Steve – thank you – yes – similar to SUMPRODUCT (which I’m embarrassed to say that I had to look up).  We changed the way that we are presenting one of our cost centers.  Previously included all the 500 accounts in an admin cost center at 100%.  We now allocate those 75% to one cost center and 25% to another for internal presentation purposes only (need to remain in admin for cost reporting purposes). 

I forgot that you no longer dealt with MR, but I knew you could point me in the right direction!

——————————
Kathy Kim
Director of Finance
Donor Network of Arizona
Tempe AZ
——————————
——————————————-

[Sally Higgins]

A quick way to do it would be to do the “CAL” of this (0-500-6010-000 to 0-500-6080-999)*.25 on one row, then add that row with a row that has the other accounts. You could do those rows as NP and then show the total

——————————
Sally Higgins
efs consulting, inc
——————————
——————————————-

[Kathy Kim]

Thanks!  I think that is what I was looking for.  Our MR reports are very simple for the most part and I haven’t had to even use CAL before.  I knew there was a way, but I couldn’t remember what it was!

Thank you!

——————————
Kathy Kim
Director of Finance
Donor Network of Arizona
Tempe AZ
——————————
——————————————-

[Sally Higgins]

You bet! You could probably also do something like this with a cal, but what I suggested will be quick and simple

Have a great day!

(0-110-6010-000:0-110-6080-999) + ((0-500-6010-000:0-500-6080-999)*.25)

Sally J. Higgins, CPA

efs consulting,inc

720-937-9552

http://www.efsconsulting.org

This communication is for its intended recipient only, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient or the employee or agent responsible for delivering this communication to the intended recipient, you are hereby notified that any unauthorized use, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone (720-937-9552) or e-mail reply, delete it from your system, and destroy any hard copy you may have printed. Thank you.

——————————————-

[Noah Moseley]

Thanks .
Hi .

I’d lean towards three rows.

ROW 1   (0-110-6010-000:0-110-6080-999) Non-printing
ROW 2   (0-500-6010-000:0-500-6080-999) Non-printing
ROW 3   CAL  Row1+(ROW2*0.25)
????

——————————
Noah Moseley, MSX Group Senior Consultant
Academy Instructor for Management Reporter
Noah.Moseley@MSXGroup.com

View our GPUG Partner MSX Group listing: https://www.gpug.com/engage/findacompany/companyprofile?UserKey=275d1f3a-73b4-4a58-b0d8-7395d682dbc3
——————————
——————————————-

[Kathy Kim]

Thank you .  I guess I was on the right track, but it’s always good to have the experts confirm that!  And it’s somewhat amazing that I can’t remember the last time that I had to create or modify a report using a calculation beyond a TOT.  ?

——————————
Kathy Kim
Director of Finance
Donor Network of Arizona
Tempe AZ
——————————
——————————————-

[Kathy Kim]

  Thanks again!  I was able to successfully alter the row to do the calculation I needed.  Very simple with a little guidance.  Much appreciated.

I went with two NP rows and then the calculated row.
???

——————————
Kathy Kim
Director of Finance
Donor Network of Arizona
Tempe AZ
——————————
——————————————-