Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Forums › IT Pro and developers › MySQL Query for rounding numbers to 100%
sonyxperiageek

2984 posts

Uber Geek
+1 received by user: 397

Trusted

#232202 4-Apr-2018 15:46
Send private message

I've got four MySQL Queries where I need it to round to 100%, but I get the occasional one that rounds lower than the others meaning my total % is 99. Is there a quick and easy way of doing this, or should I just get the percentage of three numbers, then 100 - the three numbers?




Sony

Create new topic
sampler
468 posts

Ultimate Geek
+1 received by user: 126

ID Verified
Trusted
Lifetime subscriber

  #1988292 4-Apr-2018 16:44
Send private message

Maybe use the ceil(....) function?

Would need to see the statement to have some understanding of what your trying to do?



jonherries
1433 posts

Uber Geek
+1 received by user: 316

Trusted
Subscriber

  #1988332 4-Apr-2018 18:23
Send private message

I would never use a sql query to reduce accuracy (efficiency, reuse etc). Should be applied as a mask or formatting at the end?

Jon

Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.








RSS feeds
Main feed
Forums feed
Copyright
©2002-2026 Geekzone®
Site features
Geekzone BI dashboard
Geekzone Badges
Geekzone Status Page

 

Site Information
Subscribe to Geekzone
Privacy Statement
Forum Usage Guidelines (FUG)
Advertising
Trademark and copyright