web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Management Reporter - ...
Microsoft Dynamics AX (Archived)
Answered

Management Reporter - Multiple calculations in a Column

(0) ShareShare
ReportReport
Posted on by Lobesuk 40

Please can someone advise if multiple calculations can be achieved within a Column?

I understand that IF and THEN statements can be used but I have not been able to apply this successfully to my scenario.

For example, I want my Column D to calculate:

If Row number = 110 to 150, then = C

If Row number = 160 to 200, then = C-B

If Row number = 210 to 250, then = B-C

As a workaround, I can achieve this using non-printing rows and column placement. However, it would make more sense to put the formula in the column.

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    April Olson Profile Picture
    April Olson Microsoft Employee on at

    Using non-printing rows and column placement is the way to accomplish scenarios like this, which is what you are currently doing. You are correct in that type of formula is not accepted in the column definition. I would enter a suggestion on the Connect.microsoft.com site with the scenario of why you need a calculation like this. Entering on this site allows customers to vote on it if they need the same functionality.

    Here is a blog to help you get started with the Connect site if you are not already registered: blogs.msdn.com/.../influence-financial-reporting-and-budgeting-features.aspx

  • Lobesuk Profile Picture
    Lobesuk 40 on at

    Hi April. Thanks for the reply, its much appreciated.

  • az_greengirl Profile Picture
    az_greengirl 15 on at

    Can you tell me how were able to have column D displaying your scenario above using the non-printing rows?  I am wanting Column D to use C-B for all rows, except for one row to use B-C, but cannot determine how.

  • Lobesuk Profile Picture
    Lobesuk 40 on at

    Hi Jess

    This is a very old post which brought back some memories :)

    I believe the workaround was:

    1. Create a non printing row to calculate the values (For example row 220)

    2. Create a new Calculation Row which will be printed

    2. Use Column Placement to override the formula's. For example, B=B.220, C=C.220, D=(B.220-C.220)

    You may also need to adjust the Calculation Priority.

    I hope this helps.

    Shaun

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sanhthosh.Kumar.K Profile Picture

Sanhthosh.Kumar.K 2

#2
Raed Salah Bzour Profile Picture

Raed Salah Bzour 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans