How would I create a column that gets the sum of all columns with the same hbl column?
I have a shipment table where I was able to create a relation to show the names of the charges. But I’m unable to figure out from similar threads how to get the sum of the prices for each hbl.
Create a Relation or Query column to link similar data, then create a Rollup column and point it to that relation or query.
This is exactly what I was looking for, thank you!
Can you suggest a way to take this one step deeper by factoring in the currency? For example, I would only want to add related rows where the currency is USD. Then separately, if the currency is EUR, I’d like to add all EUR charges in a separate column.
Use the Currency as a filter in the Query column.
