i need to sum the total amount in the form

Service Code

Service Description

ManHour

Labor Rate

Total Amount

<<Start:[Related WorkOrder_Services]>><<[ServiceCode]>>

<<[ServiceDescription]>>

<<[ManHours]>>

<<[LaborRate]>>

<<[TotalCost]>><>

TOTAL

???

Then you need to do it in a Viritual column, or set the SUM() expression in Initial value and enable Reset on edit.

2 Likes

When setting up a view you can set a summary value that can sum a column.

2 Likes

<<SUM([Related WorkOrder_Services][TotalCost])>>

4 Likes