BlancaAnderson
6 years agoQrew Assistant Captain
Counting Varies Depending on Multiple Choice Selected
I have a multiple choice field that displays the following:
-NONE
-A
-B
-C
-D
I need a new formula field that displays "0" if NONE is selected and then if any other letters are selected to add them up.
So if unit
101 needs BD = 2
102 NONE = 0
103 AD = 2
104 C =1
Please help me with the formula. I tried looking in the knowleadgebase but didn't see a case where if a certain selection in my case NONE would equal to "0" and count if any others.
I can provide screenshots if needed.
-NONE
-A
-B
-C
-D
I need a new formula field that displays "0" if NONE is selected and then if any other letters are selected to add them up.
So if unit
101 needs BD = 2
102 NONE = 0
103 AD = 2
104 C =1
Please help me with the formula. I tried looking in the knowleadgebase but didn't see a case where if a certain selection in my case NONE would equal to "0" and count if any others.
I can provide screenshots if needed.