3 Replies Latest reply on Feb 14, 2020 9:15 AM by Rohit Yeruva

    Showing all values for a float parameter

    Jayanth Srinivasan

      Hello,

       

      I have been trying to figure out how to display all values for a parameter when its a float. I see solutions for parameters using string. I have 2 float parameters for trxn amount and count, with values ranging from 0-1. I am trying to create a 2 way parameter analysis which will display values that meet my "kth value" for all possible combinations (screenshot below), can someone please guide me on how to do this?

       

      My K Value Parameters

       

       

      Sample of what I am trying to achieve:

       

       

       

      I'd really appreciate any suggestions and inputs on this.

        • 1. Re: Showing all values for a float parameter
          Rohit Yeruva

          Hey Jayanth,

           

          Can't you use calculated fields instead. Also, do you have a sample workbook that you can attach?

           

          Regards,

          Rohit

          • 2. Re: Showing all values for a float parameter
            Jayanth Srinivasan

            Do you mean something like this? I dont have a workbook to show as it has some client data in it but if there is no other alternative, I can mock up some data

             

            IF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],.1)}

                THEN "<10th" ELSEIF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],.2)}

                    THEN ">10-20th" ELSEIF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],.3)}

                        THEN ">20-30th" ELSEIF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],.4)}

                            THEN ">30-40th" ELSEIF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],.5)}

                                THEN ">40-50th" ELSEIF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],.6)}

                                    THEN ">50-60th" ELSEIF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],.7)}

                                        THEN ">60-70th" ELSEIF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],.8)}

                                            THEN ">70-80th" ELSEIF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],.9)}

                                                THEN ">80-90th" ELSEIF [Transaction Pair Amount]<={FIXED :PERCENTILE([Transaction Pair Amount],1)}

                                                    THEN ">90th" END

            • 3. Re: Showing all values for a float parameter
              Rohit Yeruva

              Yup, something similar and whatever works for you. Helps if you can fabricate some data and upload your problem along with what you finally want.