News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Field Calculations in ...

Microsoft Dynamics AX (Archived)

Field Calculations in form

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi All,

I have a customised form, need to calculate some fields in that form. where can i do coding for this calculation?

How can i complete my requirement? Please suggest me!

*This post is locked for comments

All responses Img

All responses (4)

Answers Img

Answers (3)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Field Calculations in form

Hi Devid,

Try this code!
public void modifiedField(FieldId _fieldId)
{
   YourTable yourTable;

   super(_fieldId);

    switch (_fieldId)
        {
            case fieldNum(YourTable, opening balance):
            case fieldNum(YourTable, closing balance):

            this.Actual balance = this.opening balance - this.closing balance

            Break;

       }

}

Thanks

Suresh
Community Member Microsoft Employee on at

Like (0)

Report

RE: Field Calculations in form

Hi Tatiana Garcia Ramos and Suresh potlakayala

Thanks for your response, I'm expecting Actual balance = opening balance - closing balance.

Can you please suggest any code for this?
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Field Calculations in form

Hi Devid,

You can do this calculation in multiple ways!

1.In table you can do this by using ModifiedField method.

but it will effect on everywhere which you used that calculation.

2.In form design> wherever you want do that calculation you need to do coding in that field.

in that field > modified field > do code here!

this type of calculations will be done in form level, this is the best practice

Please refer my blog, it may usefull for you.

http://axsuresh.blogspot.in/2016/03/table1.html

Thanks

Suresh
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Field Calculations in form

the best way to do it, is creating a new display or return method in the table.

Add a string control in the form and call the method in the table, otherwise your calculation will always show in all the records in the grid the same value.

Try this, and if you have more question I will help.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans