Forum Discussion
CrgJnr
2 years agoFrequent Visitor
Simulation changing parameters for each row
I would need to create a dashboard with manual entries to do simulations, moving away from managing this situation in Excel. Specifically, the objective is to have an overall cost value and an o...
vanessafvg
2 years agoCommunity Champion
it is only in doing you would figure that out, in order for me to absolutely know, the devil is the in details, which i dont have enough to answer, as well as understanding the input vs that output, the data model, there are many nuances in data, so you would need to provide sample data that that has all your scenarios. without that i dont have enough information to tell you absolutely this will work.
in theory you should be able to write code or use filters to direct your what if scenarios.
try one and see if it meets all your requirements.
CrgJnr
2 years agoFrequent Visitor
I've changed my question with a sample of data...
Thank u!