Skip to main content

Notifications

Microsoft Dynamics AX forum

Management Reporter Calculation Field

Posted on by 530

Hi,

Is there any way to provide calculation in the column from specific row values ? 

for example :

 report-sample.jpg

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter Calculation Field

    Hi ahmed.kimo,

    I am not aware that such references are possible in MR calculations.

    You can certainly give it a try but I doubt that those formulas work.

    Best regards,

    Ludwig

  • ahmed.kimo Profile Picture
    ahmed.kimo 530 on at
    RE: Management Reporter Calculation Field

    Hi Dr,

    I got your point, so there i no way to know the selected company in the row definition like @CompanyName @CompName ,

    and i should use it from report tree as a unit @unit(DAT:Sales)  @Unit(USMF:Sales) , i'm a correct ??

    it's ok , is there any way to use @Unit(DAT:*) i mean all units in this company with in the reporting tree ?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter Calculation Field

    Hi ahmed,

    This calculation would only work if your company is setup as a financial dimension. If this is the case, then you can make use of an if-then-else calculation formula. At the bottom of the following site you can find examples how to setup if-then-else calculations.

    msdn.microsoft.com/.../dn464327.aspx

    Best regards,

    Ludwig

  • ahmed.kimo Profile Picture
    ahmed.kimo 530 on at
    RE: Management Reporter Calculation Field

    HI Dr,

    Here is the full example 

    7217.ex.jpg

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter Calculation Field

    Hi ahmed.kimo,

    I do not fully understand your last question.

    Can you elaborate on that and possibly provide a simplified example that helps me understanding this?

    Many thanks and best regards,

    Ludwig

  • ahmed.kimo Profile Picture
    ahmed.kimo 530 on at
    RE: Management Reporter Calculation Field

    Hi Dr. Ludwig Reinhard

    i need to do calculation in the row itself based on the current company for example, i'm using same row definition for all companies (legel entity) but in particular row i need to check if the current company = DAT then print 10*10  else if company = USMF then print 10*15 else 0

    is there any way to achieve that instead of replicate the row definition?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter Calculation Field

    Hi ahmed.kimo,

    To my knowledge, this is not possible. You would have to include the Arabic and English description into one single column possibly separated by a dash.

    Best regards,

    Ludwig

  • ahmed.kimo Profile Picture
    ahmed.kimo 530 on at
    RE: Management Reporter Calculation Field

    Hi,

    Is there any way to have two columns for the description for example :

    Description Arabic | Description English

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter Calculation Field

    Hi ahmed.kimo,

    In AX you have to ensure that you record your revised budget with a separate Budget model.

    7802.mr1.png

    So instead of using a single budget model (FY2014 in my screenprint). The budget revisions need to be recorded with a different model (for example FY2014-REV1)

    Once that is done you can select the budget model in the column definition. Example:

    7802.mr1.png

    Hope this helps.

    Best regards,

    Ludwig

  • ahmed.kimo Profile Picture
    ahmed.kimo 530 on at
    RE: Management Reporter Calculation Field

    Hi,

    It's ok , but how i can achieve that ?

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans