I am having trouble implementing this.
I want to sum the Line Total by Unique ID. That is I want a sum for all of the line totals that have the same unique id.
I have a Unique ID for each line that comes from A Work Orders file, this work fine.
I have a Relation set up on Unique ID that is multi (see pic).
I have a rollup column that sums line total but is bringing back all the line totals, not just the one (see pic).What am i doing wrong. Many thanks …
