Solved

# percentage remaining

Posted on 2016-09-20
Medium Priority
87 Views
We put engines on the planes, Each engine has time_since_new - eg 22538 (in hours)

We also have a customer profile that we say that for this customer the life limit hours is 50000 ( hours)
Now I want to calculate the percentage time remaining

I do 50000 minus 22538 and then get the percentage? Help appreciated.
0
Question by:anumoses
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3
• 2

LVL 28

Accepted Solution

Bill Bach earned 1000 total points
ID: 41807013
(TotalLife - UsedLife) / TotalLife * 100%, or (50000 - 22538)/50000 * 100%.
0

LVL 6

Author Comment

ID: 41807020

As you mentioned this seems correct
0

LVL 6

Author Comment

ID: 41807038
select round((50000 - 22538)/50000 * 100,2) from dual

I get 54.92 percent remaining
0

LVL 3

Assisted Solution

awed1 earned 1000 total points
ID: 41807048
1- [Current hours (22538)/Total hours(50000)]=%of hours remaining.
1-.45076 = .54924 which is 54.924% rounds to 55%
0

LVL 28

Assisted Solution

Bill Bach earned 1000 total points
ID: 41807052
Exactly.  If you didn't want the value as a percentage, simply eliminate the *100 and you'll be left with a decimal value.
0

LVL 6

Author Closing Comment

ID: 41807179
Thanks
1

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For manyâ€¦
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the dâ€¦
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
###### Suggested Courses
Course of the Month12 days, 4 hours left to enroll