getting %

[savok]

whats the best way to find out what % 158,189 is out of 632,756? rounded to the nearest tenth?

thanks

 

[Karl Blessing]

632756/158189 = 4
100/4 = 25
formatnumber(25,2) = 25.00 %

so um, basically let me try another example , something that'll show a bunch of percentages.

128/13 = 9.84615384615384615384615384615385
100/9.84615384615384615384615384615385 = 10.1562500000000000000000000000009

formatnumber(10.1562500000000000000000000000009, 2)
= 10.15 % Karl Blessing aka kb244{fastHACK}

 

[Karl Blessing]

or....

you can do this

formatnumber((lowernumber/highernumber)*100, 2) Karl Blessing aka kb244{fastHACK}

 

[savok]

thanks

 

[Mongooses]

KB - won't using FormatNumber truncate not round and to the nearest tenth percent would be 1 decimal place.

Savok - Round(FormatPercentage(158189/632576),1) will do the division and automatically multiply by 100 and the ",1" will round to the nearest tenth.

HTH,
JC

 

[petermeachem]

I don't believe the round function works as expected when the argument is something.5 . If you want to consistently round, use your own algorithm.

 

[jmarler]

petermeachem,
Yes, you are correct. The round algorithm uses a "financial Rounding" method. In VB, you will get this . . .

Round(1.5) = 2
Round(2.5) = 2
Round(3.5) = 4
Round(4.5) = 4

Essentially. when rounding odd number with 1/2 the number is rounded up and even numbers are rounded down. A more "classical" approach to rounding would be to say this . . .

SomeNumber = the number to be rounded.
decimalplace = the decimal position to round to (base 0)

SomeNumber = 2.5
SomeNumber = Int(SomeNumber * (10^decimalplace) + .5)/(10^decimalplace)

- Jeff Marler B-)

 

[petermeachem]

Yes, you have to be careful with tax values. In the UK we always round up VAT (Value Added Tax) to avoid the taxman getting all stressy.

 

[jmarler]

petermeachem,
Taxman . . . grrrrrrrrrr - Jeff Marler B-)

 

[jmarler]

petermeachem,
Taxman . . . grrrrrrrrrr >:-< - Jeff Marler B-)