1 Reply Latest reply on May 23, 2016 1:12 PM by msa s

    Multiple parameter slides based on single field

    George Bailey

      I have a field called regions (values: North, South, East, West) and I would like to give the users the ability to set parameters

       

      Region Parameter

      -North (default = $100 -- let the user slide from $0 to $200)

      -South (default = $200 -- let the user slide from $0 to $400)

      -East (default = $200 -- let the user slide from $0 to $400)

      -West (default = $250 -- let the user slide from $0 to $500)

       

       

      I want to create a Calculated Field called "Total Potential" and the formula will equal: [# of units] * [parameter]

       

      Records

      -Record 1    (Region=North) and [# of Units]=10    * (user parameter: 50) = 500

      -Record 2    (Region=North) and [# of Units]=20    * (user parameter: 50) = 1000

      -Record 3    (Region=East) and [# of Units]=10    * (user parameter: 200) = 2000

      -Record 4    (Region=West) and [# of Units]=10    * (user parameter: 5) = 50

      -etc.

       

      How do I create the user parameter with a field (example Region) that has multiple values.

       

      Thanks