how do you convert "percentage equivalent"
Example: Range 96 - 100
94 - 95
91 - 93
to - "numerical equivalent"
Example: Value of 96 - 100 = 1.00
94 -95 = 1.25
91 - 93 = 1.50
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.
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
NumberFieldStart = GetAsNumber ( LeftWords ( Range ; 1 ) )
Hope this helps.
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?
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.
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.....
How 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 auto-enter 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.
Great suggestion Stephen Huston thank you very much!!!
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 auto-enter 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.
Retrieving data ...