Hi all,
I would like some help with a what if scenario. The attached files is quite straightforward. I have 4 expressions. 1. Total Products manufactured, 2. Total Days it took to manufacture those products, and 3. What is the average Products Per Day. I have created a variable vUplift=0 and created a slider object linked to the 'Projections' column (4th expression). What I would like to have is:
Scenario 1:
If the average Products Per Day goes up, how many fewer days (TotalDays) I need to manufacture the same number of Products (TotalProducts). Basically, when the value in the Projection column goes up (through the slider), the value in TotalDays column should DECREASE simultaneously. The Total Products column should remain static.
Scenario 2
Similar to the above but the difference is I would like to know how many more Products (Total Products) I can manufacture when the average Products Per Day goes up. Here, the TotalDays will remain static but the Projection column and TotalProducts column should INCREASE.
Not sure if we can do this in the same table, but I am happy to do this in a separate table if required:
Thanks for your help in advance.
