I’m looking to make an interactive tool whereby I can examine the effects of ingredient level and cost on goal formulation cost.
My data table is currently: ING Name, ING cost, ING inclusion level, ING cost per formulation (which is a formula of cost * inclusion level) and a final formula column for total cost.
I’ve tried to use fit model to get the profiler to give me an interactive way of changing each variable to see the resulting total cost, but not getting what I want.
Any help would be greatly appreciated
