https://gyazo.com/f6559c5f964af237ed080356f24a1c97 Is there a way to get that specific value without looping through every item in the sublist?

the totalling field can be set via “Sublist.updateTotallingFieldId(options)” but not sure how to read other than possibly some DOM scripting

My current work around is looping through the expense items (which are less lines) and subtracting the expense total from the overall total.

is it that much quicker? can’t imagine you lose so much time simply looping through the items themselves (instead of expenses). . . Of course, not looping at all would be ideal. not sure

Well in the case of there not being expenses, it will be a lot quicker because total - 0 = total Also if a PO has a lot of lines, looping through 1-3 lines is a lot quicker than looping through 50-100

@Jared Fraley I'm not sure, but what if there are other sublists in the record that also contributes to the total? Won't that break your logic?

@Joe Thomson I am working with the Purchase Order record, and there are only 2 sublists that contribute to the Total (Items and Expense)

@Jared Fraley 😄👍 I've seen multiple sublists in an invoice (see screenshot).

@Joe Thomson This is for a PO Re-Approval workflow, I just needed to distinguish only changes where item total amount went up, this is the best solution I have haha