News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... AL language. If condt...

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

Suggested answer

AL language. If condtion on columns

(0) Share

Report

Report

Posted on by aqeel2020uae

62

Dears.

I am creting a query type=API

In Sales Line table i have 3 lines .

1-Item1 /UOM=PCS =Total 100

2-Item2 /UOM=PCS =Total 50

3-Item3/UOM=Service Total 5.

Grand Total =155.

But on Sales Hader Level i am getting all fields but i want to add two columns Total

If Item UOM =pcs then TotalItemsSold 150

If Item UOM =Service then Total ServicesValue =5

How i can use If condtion or Filter to Sum up Sales Line based on condtion on field UOM.

Thanks in advance.

Aqeel.

Categories:

Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (0)

Report

AL language. If condtion on columns

Hi, as far as I know, it can't be done using Query.

When using Page, you can specify conditions in the field's Visible Property and you can also add calculation logic, but this cannot be used in Query.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-visible-property?wt.mc_id=DX-MVP-5004336

Or, you create two Query APIs respectively, UOM =pcs calls A, and UOM =Service calls B. But this is a bit troublesome.

Or you can simply try $filter.

https://yzhums.com/6117/#toc8

Hope this can give you some hints.

Thanks.
ZHU

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans