Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

Issue with percentages and 1

I have an issue with one of my reports and so to test it I opened up the Immediates pain window and entered the values that I wanted:

I simply want to find 1% of 1052

?(1/1052)*100
 9.50570342205323E-02

It should be 0.095057034

What am I doing wrong?
0
Andy Brown
Asked:
Andy Brown
  • 6
  • 4
  • 2
  • +1
1 Solution
 
Rey Obrero (Capricorn1)Commented:
nothing... that is correct,
try



?format((1/1052)*100,"percent")
0
 
bluelizardCommented:
correct me if i'm wrong, but wouldn't p% of n be calculated like this:

   n * ( p / 100 )

?

if so, you'd find

? 1052 * ( 1 / 100 )
  10.52

no?

what am i missing here?


--bluelizard


0
 
Andy BrownDeveloperAuthor Commented:
Thanks everyone - but so far not quite their

I am looking at call outcomes and counting how many of each there are.

Call back = 151
Company no longer trading =4
Company will not release information =27
Current customer = 8
Dead line =10
Do not Sell to Consumer = 201
Duplicate record = 107
Face to face appointment = 29
Information requested via email = 1
No Financeable Products = 244
No interest = 1
Overseas = 22
Parked = 208
Unobtainable / does not return calls = 6
Wrong number = 33

This totals 1052.  I simply want to put alongside the value what percentage that is.  For example; Wrong numbers (33) = 3.136882129% etc.  But it falls over on the very small numbers?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Rey Obrero (Capricorn1)Commented:
< But it falls over on the very small numbers?> How?
0
 
Andy BrownDeveloperAuthor Commented:
I have a table with

Outcome, Qty, Percentage
Wrong number, 33, 3.1

All of the bigger numbers appear to be correct, but on the very small number (Information requested via email. 1) it comes up with an inflated percentage figure of 9.505, when it should be 0.095057034.

0
 
Rey Obrero (Capricorn1)Commented:
converting 9.50570342205323E-02  by removing the E-02 (means shift the decimal places to the left by 2 spaces) will give you

0.0950570342205323

0.095057034

so basically they are the same
0
 
Andy BrownDeveloperAuthor Commented:
How do i do this?
0
 
Andy BrownDeveloperAuthor Commented:
Thinking about it can I detect the E-02 and then fix it - or is there a better way?
0
 
Rey Obrero (Capricorn1)Commented:
you may just need to format the results.
did you try this

?format((1/1052)*100,"percent")
0
 
Andy BrownDeveloperAuthor Commented:
That works fine for this instance of 1, but the other larger values to come through correctly.  It's not just 1 either, 2, 3 4 also seem to have the same issue.  Its funny, if you type in the same equation into Excel, it works perfectly =sum(1/1052)*100.
0
 
Gustav BrockCIOCommented:
Use either:

strPercent = Format(x / 1052, "percent")
which returns for x = 1 the rounded value 0.10%

or, if you wish four decimals:
strPercent = Format(x / 1052 * 100, "0.0000")
which returns for x = 1 the string 0.00951

/gustav
0
 
Andy BrownDeveloperAuthor Commented:
Thanks for your help on this - sorry for the delay in getting back to you.
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 6
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now