Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Management Reporter - Multiple calculations in a Column

Posted on by 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

  • Lobesuk Profile Picture
    Lobesuk 40 on at
    RE: Management Reporter - Multiple calculations in a Column

    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

  • az_greengirl Profile Picture
    az_greengirl 15 on at
    RE: Management Reporter - Multiple calculations in a Column

    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
    RE: Management Reporter - Multiple calculations in a Column

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

  • Verified answer
    April Olson Profile Picture
    April Olson on at
    RE: Management Reporter - Multiple calculations in a Column

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans