Forum Discussion

dreww12345's avatar
dreww12345
Icon for Helper I rankHelper I
5 years ago
Solved

Compute result based on user entered quantity

Hi   I am working on a dashboard that will show my employees the amount of raw materials required for a production item.   For example,    1 unit of production item C-1234 may require 3 units o...
Need Help
Tutorial Requests
  • samdthompson's avatar
    samdthompson
    5 years ago

    Hello, yes this is possible using parameters. Go to the modelling tab and the parameters button. This is a GUI version of making a table with GENERATESERIES(). You can then use the list of numbers as multipliers for your scenario in any calculation.

     

     

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
5 years ago

Hello, yes this is possible using parameters. Go to the modelling tab and the parameters button. This is a GUI version of making a table with GENERATESERIES(). You can then use the list of numbers as multipliers for your scenario in any calculation.