
1. Re: Convert Percentage to Numerical
itraining Jun 19, 2013 8:23 PM (in response to louie23)Assuming you have 2 Number fields to enter the start and end of each range.
For example NumberFieldStart contains 96 in the 96  100 range.
Case (
NumberFieldStart >= 96 ; 1.00 ;
NumberFieldStart >= 94 ; 1.25 ;
NumberFieldStart >= 91 ; 1.50 ;
and so on
)
Alternatively, if the range is in a Text field:
For example: the field called Range contains data 96  100
Let (
NumberFieldStart = GetAsNumber ( LeftWords ( Range ; 1 ) )
;
Case (
NumberFieldStart >= 96 ; 1.00 ;
NumberFieldStart >= 94 ; 1.25 ;
NumberFieldStart >= 91 ; 1.50 ;
and so on
)
)
Hope this helps.
Michael Richards
Brisbane (Australia)

2. Re: Convert Percentage to Numerical
louie23 Jun 20, 2013 3:46 AM (in response to itraining)thanks Michael Richards I'll try this
But, the result of lets say 87, 89, 91, 92, 93, 94, and so on is a result of Calculation.
Now, is that possible to convert the results of that calculations to numerical value?
Thanks

3. Re: Convert Percentage to Numerical
jbante Jun 20, 2013 5:33 AM (in response to louie23)It isn't clear to me what you mean by "numerical equivalent". Can you explain for me what the context of this is? Can you explain what you mean by "numerical equivalent" in more detail? Usually, when I hear about converting percentages, the problem is converting numbers from the range 0  100 to an appropriate number in the range 0  1; but you're trying to do something completely different, judging by your example.

4. Re: Convert Percentage to Numerical
louie23 Jun 21, 2013 2:58 PM (in response to jbante)Numerical equivalent is simply an official marks being used in our School in College. Instead of recording "percentage equivalent" such as 85, 86, 87, 88, 89, 90 and so forth. We use "numerical" so instead of recording those who got in range of 96  100, we give 1.00 which is the equivalent of that score ( 96  100).
This is just I wish to see with the result, named "Numerical Equivalent" which is the result from the calculation I already made, the Percentage Equivalent:
Here are the details:
Percentage Equivalent Numerical Equivalent
96  100 = 1.00
94  95 = 1.25
91  93 = 1.50
88  90 = 1.75
and so on.....
Thanks

5. Re: Convert Percentage to Numerical
Stephen Huston Jun 21, 2013 3:23 PM (in response to louie23)1 of 1 people found this helpfulHow about a calculated result text field: (text if you want it to retain 0s in the decimals)
Case ( PercentEquiv ≥ 96 ; "1.00" ; PercentEquiv > 94 ; "1.25" ; etc... (as far out as your NEs go)
The calc will test until it hits a "True" result and return that match.
You can even make it an autoenter stored field Evaluated by calc so it will update as the PE number is entered or changed, and then it can be stored rather than using an unstored calc. This will spead up reporting down the road.

6. Re: Convert Percentage to Numerical
louie23 Jun 21, 2013 3:34 PM (in response to Stephen Huston)Great suggestion Stephen Huston thank you very much!!!

7. Re: Convert Percentage to Numerical
jbrown Jun 21, 2013 3:35 PM (in response to louie23)You could set up another table with the conversion information: ( do this all the time in my students and grades database)
PercentageHigh PercentageLow NumberEquivalent are the fields. The first two are the range of the percents.
Then set up a relationship from the grades table to this Conversion Table that is set up by using this:
Grades::percent >= Conversion::PercentageLow AND Grades::percent <=Convsersion::PercentageHigh.
Use this relationship to autoenter the Number Equivalent field in the grades table.
(You could also do this with an executeSQL statement, forgoing the new relationship described above).
This is a bit more complicated but it allows for you to change the percentage range and still have the conversion work without having to go into the field definition.
jb