Requisition Entry - Total Value of all Lines in Header JSON help needed

[jbooker (Josh Booker)]

You could do the sum client-side without a need for the UD column like so:

App Studio - Dashboard - Create Calculated Fields

Client-side you could use in a row-update an expression to get the count of rows in a dataview like so: %YourDataView.count% or an aggregator js function to sum values of those rows like so trans.dataView('YourDataView').data.reduce((sum, item) => sum + item.QuoteHed_QuoteAmt, 0) Or aggregate by key like so trans.dataView('PartCountsByVer').data.reduce((a, x) => (a[x.Part_CommercialCategory] = (a[x.Part_CommercialCategory] || 0) + x.Calculated_CountOfPartNum, a), new Object()).PIPE …

Textbox > epBinding > TransView.TotalLineValue
Event: trigger on KeyValue changed
Row-update > TransView.TotalLineValue

Expression:

trans.dataView('ReqDetail').data.reduce((sum, item) => sum + item.DocExtCost, 0)