1 Reply Latest reply on Jun 7, 2018 7:57 AM by Mavis Liu

    "Sliding Price Parameter"

    Aaron Duncan

      Hey all this should be a pretty easy solution but i am having issues;

       

      I want to create [what i think should be a parameter] that will allow end users to enter whatever value they want ($1, $1.34, $100.58 etc) and then multiple a value in the database (# of people) by the $$$ amount which is not in the database.

       

      Is there a way to do this, data is confidential so i cannot share, however i can try and explain.

       

      User filters by job type > gives # of workers

       

      User enters variable field ($$$) in what i suspect to be a parameter

       

      Calculation shows [# of workers * $$$]

        • 1. Re: "Sliding Price Parameter"
          Mavis Liu

          Hi Aaron,

           

          Yes you should use a parameter, first click on the dropdown and select create parameter:

           

          2018-06-07_15h52_08.png

           

          Set the type as float and display format as currency custom with 2 decimal places with the currency symbol, then click ok.

          2018-06-07_15h52_33.png

           

          Next thing to do is LINK this parameter to the dataset. To do this, create a calculated field. Click on the drop down from the very first step and create the below calculated field:

           

          2018-06-07_15h55_22.png

           

          So in my example, I am multiplying sum of sales by the multiplier amount in the parameter.

           

          Next thing is to USE this calculated field, so I'm going to put it on my rows:

           

           

           

          2018-06-07_15h55_56.png

           

          When you change the value in the parameter it will update the chart.

           

          I've attached a workbook so that you can take a look.

           

          Thanks!

           

          Mavis

          1 of 1 people found this helpful