So I have a family with a Formula Parameter. For simplicity sake let's say it's
Area / 25
Is it possible to change the Formula by Type?
(never mind that these formulas don't make sense in any practical application. They're just for illustration)Type A, I want Area / 25
Type B, I want Area * 100
Type C, I want (Area / 3) + 2
Now, I know I can do this with a nested conditional statement...
But... I may have 30 different types. The conditional statement is guaranteed to get very long, and very complex. It would be difficult, if not impossible, to add a new type. Furthermore, Type D might be a conditional in and of itself.IF(Type = A, Area / 25, IF(Type = B, Area * 100, IF(Type = C, Area / 3 +2, 0)))
Ideally, I would like a Type_Formula parameter, that is an expression of the desired formula. Then as the type changes, the actual formula changes too.
Does anyone know if this is possible?