web

You’re offline. This is a read only version of the page.

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

271

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:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 93,872 Super User 2025 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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sumit Singh 2,179

#2

OussamaSabbouh 1,999

#3

YUN ZHU 1,892 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans