
1. Re: Adding values & sum to multiselect picklists (Salesforce)
lenaic.ridinger Oct 25, 2016 7:48 AM (in response to Adam Serota)Hi Adam Serota,
I don't see any issue in there... does anyone in the community can spot the problem in this calculation please?
In the meantime Adam, could you please provide us with a workbook (.twbx)?

2. Re: Adding values & sum to multiselect picklists (Salesforce)
Alan Asher Oct 25, 2016 9:50 AM (in response to Adam Serota)Adam, this is how I would do it (assuming [Days] is a standard pick list in Salesforce: Then remember to choose 'Measure (Sum)' once you drop this custom calc into your viz
IF CONTAINS([Days], 'Monday') then 1
ELSEIF CONTAINS([Days] = 'Tuesday') then 1
ELSEIF CONTAINS([Days] = 'Wednesday') then 1
ELSEIF CONTAINS([Days] = 'Thursday') then 1
ELSEIF CONTAINS([Days] = 'Friday') then 1
ELSEIF CONTAINS([Days] = 'Saturday') then 1
ELSEIF CONTAINS([Days] = 'Sunday') then 1
ELSEIF CONTAINS([Days] = 'MF') then 5
ELSEIF CONTAINS([Days] = 'MS') then 7
ELSEIF CONTAINS([Days] = 'SS') then 2
END