web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Management Reporter - ...

Finance | Project Operations, Human Resources, ...

Unanswered

Management Reporter - Column calculation for specific rows

(0) Share

Report

Report

Posted on by ChristineMA

5

Hello, I am trying to prepare a simple variance report with a column definition that shows a +Favorable and -Unfavorable variance.

The following are my rows:

Revenue

COGS

Expense

The following are my columns

Budget, Actual, Variance

In my Variance column, how do I have the following formulas restricted to specific rows?

Revenue = Actual - Budget

COGS / Expense = Budget - Actual

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Greg Byer 2,588 on at

Like (0)

Report
Copy link

Link copied!

MR doesn't allow you to restrict columns to row. But, you can restrict a row to a certain column. Let's say that Column D has a calculation that is the Actual column - the Budget column. In the row definition, I could restrict a row to only appear in Column D by using the Column Restriction column. By place "D" in there, that row would only appear in Column D.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 341 Most Valuable Professional

#2

CU10121822-0 312

#3

André Arnaud de Cal... 262 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans