Hi there would someone review my expression to see where I am going wrong?
SUM (SELECT(Loads[Bale Quantity], Loads[Order Reference Column]=Orders[Order ID], True))
I have 2 tables, Loads and Orders. Loads are a nested table/children of Orders. One column in table โLoadsโ is Bale Quantity, and I would like a sum for all of the bale quantities associated with a certain order. Loads has a reference column called Order Reference Column that matches each load to an order by the Order ID (Order Id=Order Reference Column for a Parent order and a Child Load)
The expression assistant reads me back the following for the above expression:
SUM(
โฆThe list of values of column โBale Quantityโ
โฆfrom rows of table โLOADSโ
โฆwhere this condition is true: ((LOADS[Order Reference Column]) is equal to (ORDERS[Order ID])))
This seems to be exactly what I want, but the expression gives me 0 no matter what the column Bale Quantity has for its values. Any help??
Solved! Go to Solution.
Where are you attempting to put this Expression? Because right now, youโre getting a 0 because you are asking, โDoes the list of everything from [Order Reference Column] in Loads match the list of everything from [Order ID] in Orders?โ Which will never be true in this instance. You probably just want SUM(SELECT(Loads[Bale Quantity], [Order Reference Column]=[Order ID], True))
.
Where are you attempting to put this Expression? Because right now, youโre getting a 0 because you are asking, โDoes the list of everything from [Order Reference Column] in Loads match the list of everything from [Order ID] in Orders?โ Which will never be true in this instance. You probably just want SUM(SELECT(Loads[Bale Quantity], [Order Reference Column]=[Order ID], True))
.
Iโm putting it into the app formula auto compute section of column โtotal Balesโ in the Table Orders.
Thanks for the help again! That worked like a charm.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |