Announcements
No record found.
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,
You can find an example how this can be realized on this site
redbeardblogging.blogspot.de/.../how-to-do-cross-column-formulas-in.html
Please have a look at the figure that is provided and how the columns B and C are referenced.
(Column) B = @200/C.200
(Column) C = @200/C.200
You can of course make use of some more advanced calculations.
Some examples and additional information on how this can be setup is described here:
msdn.microsoft.com/.../dn464327.aspx
Best regards,
Ludwig
Hi Dr. Ludwig,
Thanks a lot for your help,
one more question if you don't mind , is there any way to get amounts from the revised budget instead of original budget ?
If your revised budget is recorded/linked to a separate budget model you can also show the revised budget amounts in MR.
It's ok , but how i can achieve that ?
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.
Is there any way to have two columns for the description for example :
Description Arabic | Description English
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.
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?
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,
HI Dr,
Here is the full example
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 16
GiacomoRovai 4
Douglas Noel 2
