News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Table field

Microsoft Dynamics NAV (Archived)

Table field

(0) Share

Report

Report

Posted on by jsshivalik

3,027

Hi

Can we create Calcfield like this in table for a field . I have Balance Amount field . I want Calcfield should be like this

Sum(Amount) - Sum(Receipt Amount)

Thanks

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

CDsilva 4,184 on at

Like (0)

Report

RE: Table field

You cannot do that.

Take the CALCIFIELD fields in variable and try

Record.CALCIFIELD(Amount);

AmtVariable:=Record.Amount;

........

same for Receipt Amt

Balance:=AmtVariable - RecptAmtVariable)
Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: Table field

No you can't. You need to create separate flowfields for the two sums (A and B) and then handling the A-B in code (you can create a field in your Page that has SourceExpression = A - B.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans