Dynamics Community Forum Thread Details

How to create a calculated column in a Query?

I would like to create a calculated column in a query object. More specifically I am looking to create a new column called "TotalPlannedTime" from the "Prod. Order Routing Line" table.

This column will be a combination of (3) columns: "Setup Time", "Run Time", and "Input Quantity".

The following is the function for calculating "TotalPlannedTime"

"Setup Time" + "Run Time" * "Input Quantity"

The following is my initial code sans "TotalPlannedTime"

query 50103 "Rel Prod Ord Line Data"
{
    elements
    {
        dataitem(ProdRtgLineExt; "Prod. Order Routing Line")
        {
            DataItemTableFilter = status = filter(<> "Finished");
            column(SystemRowVersion; SystemRowVersion) { }
            column(Status; Status) { }
            column(Prod__Order_No_; "Prod. Order No.") { }
            column(Operation_No_; "Operation No.") { }
            column(No_; "No.") { }
            column(Description; Description) { }
            column(Setup_Time; "Setup Time") { }
            column(Run_Time; "Run Time") { }
            column(Input_Quantity; "Input Quantity") { }
        }
    }
}

Is it possible to create a calculated column in a Query? If so, how is this accomplished?

Categories:

Business Central

Quick Links

Leaderboard