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

# 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
• 6
• 4
• 2
• +1
1 Solution

Commented:
nothing... that is correct,
try

?format((1/1052)*100,"percent")
0

Commented:
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

DeveloperAuthor 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 will not release information =27
Current customer = 8
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

Commented:
< But it falls over on the very small numbers?> How?
0

DeveloperAuthor 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

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

DeveloperAuthor Commented:
How do i do this?
0

DeveloperAuthor Commented:
Thinking about it can I detect the E-02 and then fix it - or is there a better way?
0

Commented:
you may just need to format the results.
did you try this

?format((1/1052)*100,"percent")
0

DeveloperAuthor 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

CIOCommented:
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

DeveloperAuthor Commented:
Thanks for your help on this - sorry for the delay in getting back to you.
0

CIOCommented:
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.