Forum Discussion
What-if Function in a Matrix
Hello! What I have is a matrix of data (below), and I need to assign a dynamic weight (via the what-if function for users) and make it changeable according to each category of a matrix and multi...
Sure. What other data do you need? Is the example at the top not sufficient?
For example, I need each building section to look somewhat like this:
| Category | Score | Weight (from what-if) | Weighted Score |
| EQUIPMENT & FURNISHINGS | 68.75% | 10% | 6.9% |
| INTERIORS | 72.39% | 20% | 14.5% |
| SERVICES | 68.23% | 35% | 23.9% |
| SHELL | 79.17% | 20% | 16.8% |
| SITEWORK | 40.73% | 15% | 6.1% |
I need the "weight" to come from a what-if function to calculate the "weighted score". How do I get it to change per building and per category?