Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Management Reporter (MR) - Is it possible to have multiple formulas on the same column?

Posted on by 10

Hi all.

I'm currently building a report to have each line of business numbers with after reallocating overhead costs.

Since we want to keep the transactions in Admin department as it is on GP, thought building a MR report would be the best way to do so. 

Everything seems to be working so far, except for the fact that I cannot put multiple formulas on the same column - I can use one percentage (ex. 10%) but is there a way to use multiple percentages as below?

pastedimage1658178723948v2.png

I was hoping I could have the actual numbers on one column and calculate the portion responsible to each LOB using different percentages (these percentages will change every month). 

Or is there any suggestion on how to build cost reallocation report on MR? 

Your help would be greatly appreciated!!

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans