Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SGVdavid626
Starting Member
2 Posts |
 Posted - 2010-03-08 : 21:50:00
|
| Hello, Im new to the SQL scene. I am currently using Oracle 9i. I am hoping to get some help on writing the program to calculate the ROA. here are some information on the acct_no's: Revenue = acct_no 310Expenses = acct_no between 500 and 570the Total Assets acct_no ranges between 101 and 193please help me figure how to input the programs to calculate ROA. i was told to use Select Distinct ((Select.... ...... ......)/ (Select... ... ...)) as ROAFrom Chart_of_Accounts_2010;I dont know how this program would work..can someone use the information i provided and create the ROA figure please? Thank you so much! still trying to get the hang of this program..only been using it for couple weeks. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-03-08 : 22:01:28
|
Can you use Microsoft SQL Server instead ?  Most of us here knows SQL Server and few knows Oracle cause this is a MS SQL Server forum 
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
SGVdavid626
Starting Member
2 Posts |
Posted - 2010-03-08 : 22:06:29
|
| actually I think I found out how to do it but the question is..is the Net Income divided by Average Assets..or Net Income divided by Total Assets? I am getting different formulas while searching online. |
|
|
|
|
|
|
NEED HELP CALCULATING Return on Assets