pls help me

Reply

Join Date: Jan 2005
Posts: 28
Reputation: haria_kishore is an unknown quantity at this point 
Solved Threads: 1
haria_kishore haria_kishore is offline Offline
Light Poster

pls help me

 
0
  #1
Oct 25th, 2005
Hi friends

Can someone help me in this pls.I have 2 tables in my DW

One is a table which have all data regarding Income and Expenditure details. The structure (columns) of the table is

ctgry_id,ctgry_nm,sbctgry1_nm,sbctgry2_nm,amount.,cmpny_id and tm_id

So the records in this table would look like

10001 Wages and salaries Bonus 1000 1001 10102
10002 Wages and Salaries Salaries 2000 1001 10102
10003 Repairs Cables 1000 1002 10103

and so on

Similarly the other table contains all the data regarding the assets and liabilities of the companies

The structure of the second table is

ctgry_id,ctgry_nm,sbctgry1_nm,opng_blnc,,addtn,ddctn,clsng_blnc,cmpny_id and tm_id

The records for this table would look like

1001 Gross Fixed Assets Land & Buildings 4.09 5 0 4.14 1001 10102
1002 Gross Fixed Assets Plant & Machinery 100 6 4 102 1002 10103
1003 Current Assets MAterial Stock 10 0 0 10 1001 0102

and so on

Now my problem is i need to generate a report where I calucate the total wages (i.e sum of ctgry_nm=Wages and Salaries) for a particular company and year and divide it by the total of Gross fixed assets (sum of Ctgry_nm=Gross Fixed Assets)

so my data should have somehing like

Gross fixed assets sum(gross_fxd_asst) sum(wages and salaries) calculation=sum(wages and salareis)/sum(gross fixed asst) cmpny nm year

Hope u got my problem. I tried this by creating a view by i m getting wrong results for one of the columns
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Oracle Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC