Hi,
Is there any way to provide calculation in the column from specific row values ?
for example :
*This post is locked for comments
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
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 ?
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
HI Dr,
Here is the full example
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
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?
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
Hi,
Is there any way to have two columns for the description for example :
Description Arabic | Description English
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
Hi,
It's ok , but how i can achieve that ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156