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

# Showing all values for a float parameter

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

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

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

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.