News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Creating a sum field

Small and medium business | Business Central, N...

Suggested answer

Creating a sum field

(0) Share

Report

Report

Posted on by marley milo

415

Hi all,

I have added 3 new fields on customer card, which hold a value, how do i create a new field that will sum up all 3 new fields?

Thanks

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 75,561 Super User 2024 Season 2 on at

Like (0)

Report

RE: Creating a sum field

Hi, you can also add "NewField := Field1 + Field2 + Field3" to OnValidate() of 3 new fields.
Suggested answer

Bilal Haider 41 on at

Like (0)

Report

RE: Creating a sum field

Hi,

1. Add that new field in table. NewField

2. Open card page in designer and show that field.

3. Go to page trigger OnAfterGetRecord

4. Write this line of code: NewField := Field1 + Field2 + Field3

Compile and check.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,354 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans