Forum Discussion
JakeRattner2
7 years agoQrew Trainee
Have you tried going back to the Length([Tubs Needed]) instead of the Count argument you're using at the end of your If-Statement?
Jake Rattner | Solutions Architect
(847) 927-1427 | jrattner@quandarycg.com
Quandary Knowledge Base
Jake Rattner | Solutions Architect
(847) 927-1427 | jrattner@quandarycg.com
Quandary Knowledge Base
- BlancaAnderson7 years agoQrew Assistant CaptainYes, I tried but, I may be doing something wrong. It returns this error. I thought maybe because it is not expecting the multiple choice textlist?
- JustinTorrence7 years agoQrew CadetBecause you are using a text list, you have to do some mapping.
Try this:
var number a = if(contains([Tubs Needed], "A"),1,0);
var number b = if(contains([Tubs Needed], "B"),1,0);
var number c = if(contains([Tubs Needed], "C"),1,0);
var number d = if(contains([Tubs Needed], "D"),1,0);
If(
contains([Tubs Needed], "NONE"),0,
$a + $b + $c + $d
) - BlancaAnderson7 years agoQrew Assistant CaptainGENIUS! That worked :)
Thank you so much, especially for your patience!