Microsoft Dynamics AX (Archived)

Management Reporter Calculation Field

(0) Share

Report

Posted on by ahmed.kimo

530

Hi,

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

for example :

*This post is locked for comments

All responses (13)

Answers (3)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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 530 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 530 on at

Like (0)

Report

RE: Management Reporter Calculation Field

HI Dr,

Here is the full example
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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 530 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 530 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.

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:

Hope this helps.

Best regards,

Ludwig
ahmed.kimo 530 on at

Like (0)

Report

RE: Management Reporter Calculation Field

Hi,

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