Hello @laura.johanssonPN37Y ,
It's possible but in the first part of your formula, you need to first specify that Box1 is clicked "alone" so it should be something like and(Box1, not(or(Box2, Box3, Box4))) so the text would be "AA" if only Box1 is clicked. However that would make the formula quite complicated ultimately.
What I would advise, is to use integer flags with a helper parameter named BOX_SCORE (name is for example). BOX_SCORE would get a value that would change according to which boxes are checked. All the boxes values would be incremental powers of 2 (very important as it prevents overlapping scores)?
- Box1's value would be 1 (2⁰)
- Box2's value would be 2 (2¹)
- Box3's value would be 4 (2²)
- Box4's value would be 8 (2³)
You would calculate BOX_SCORE with a formula like this (not sure it works properly as I don't have Revit opened right now but you would need to tweak this accordingly then).
= if(Box1, 1, 0) + if(Box2, 2, 0) + if(Box3, 4, 0) + if(Box4, 8, 0)
Then your formula would look like this :
if(BOX_SCORE = 1, "AA",
if(BOX_SCORE = 2, "BB",
if(BOX_SCORE = 4, "CC",
if(BOX_SCORE = 8, "DD",
if(BOX_SCORE = 9, "DDAA",
if(BOX_SCORE = 6, "CCBB",
""))))))
Which is way cleaner.
If you want to map all cases, you would need to go up to a 15 score as it's the maximum possible value (1+2+4+8 meaning all the boxes are checked).
