News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) There is a Syntax Error

Microsoft Dynamics NAV (Archived)

There is a Syntax Error

(0) Share

Report

Report

Posted on by jsshivalik

3,027

Hi

I have written below code in source Expression . It is giving Syntax Error

"Amount" - "Total Amount" where Status = 'Open'

Thanks

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: There is a Syntax Error

It depends on what you want to do.

You can for example create a function that performs the calculation you want and that returns a decimal result. Then you can place this function as SourceExpression of your field.

Or, you can create Total Amount as flowfield (SUM Amount where Status = open) and then create a new field where SourceExpression is Amount - Total Amount.
jsshivalik 3,027 on at

Like (0)

Report

RE: There is a Syntax Error

Hi

ok . what is the alternative

Thanks
Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: There is a Syntax Error

In SourceExpression you can't place a where clause.

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