web

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

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Query calculations

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

Suggested Answer

Query calculations

(0) Share

Report

Report

Posted on by MarisolC

103

Can I calculate a "new column" with a value from another column that has been feched with a query object?

I have a Currency factor that I have to calculate as 1/Currency Factor and show this value instead of Currency Factor, is there any way to achive this in a Query Object?

TIA!

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Vaishnavi J 3,096 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi

Yes you can create a query object with a field. .

and then go to page where you want to show the query object value.

in trigger onaftergetrecord of the page right the below logic

trigger OnAfterGetRecord

var

Query_Customer: Query BLL_QUERY_CUSTOMER;

begin

Clear(Query_Customer);

if Query_Customer.Open() then

if Query_Customer.Read() then

CustomerCount := Query_Customer.CountUnique; // assign your field value Calculatedfieldvalue :=1/ Query_Customer.Amount;

Query_Customer.Close();

end;

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

OussamaSabbouh 649 Super User 2026 Season 1

#2

Gerardo Rentería Ga... 447 Most Valuable Professional

#3

YUN ZHU 388 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans