7 Replies Latest reply on Jun 21, 2013 3:35 PM by jbrown

    Convert Percentage to Numerical

    louie23

      Hello guys,

      how do you convert "percentage equivalent"

      Example: Range 96 - 100

      94 - 95

      91 - 93

      and etc.

      to - "numerical equivalent"

      Example: Value of 96 - 100 = 1.00

      94 -95 = 1.25

      91 - 93 = 1.50

      and etc.

      Thanks!

        • 1. Re: Convert Percentage to Numerical
          itraining

          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

            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

              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

                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

                  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.

                  1 of 1 people found this helpful
                  • 6. Re: Convert Percentage to Numerical
                    louie23

                    Great suggestion Stephen Huston thank you very much!!!

                    • 7. Re: Convert Percentage to Numerical
                      jbrown

                      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.

                       

                      jb