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?
