How do I get the total sum of prices when I select multiple items from a list?
There are prices associated with these descriptions on a different table, and Iโd like to get the total of everything I selected. What is the best way to do this?
Solved! Go to Solution.
โcreate the list that used the โvalid ifโ constraintโ, huh?
SUM( [EnumList][Price column] )
should work fine. If not, thereโs something wrong.
I recommend using IN()
instead of CONTAINS()
, and properly using [_THISROW]
.
SUM( SELECT(
Scenario Options[Estimated Project Cost] ,
IN( [Project Description] , [_THISROW].[Select Scenario Options] )
) )
Is the EnumList base type Ref?
Yea, I finally got it to work just nowโฆ SUM(SELECT(Scenario Options[Estimated Project Cost], CONTAINS([Select Scenario Options],[Project Description])))
The Sum([Item][Price]) formula doesnโt want to work when I create the list that uses the โValid Ifโ constraint.
โcreate the list that used the โvalid ifโ constraintโ, huh?
SUM( [EnumList][Price column] )
should work fine. If not, thereโs something wrong.
I recommend using IN()
instead of CONTAINS()
, and properly using [_THISROW]
.
SUM( SELECT(
Scenario Options[Estimated Project Cost] ,
IN( [Project Description] , [_THISROW].[Select Scenario Options] )
) )
Thanks.
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |