can anyone help me in the wt avg problem

[#1]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6758.WiproInfy1.xlsx:550:0]

Hi all...

I attached one excel file here...

Wen i did the wt avg for the data,the values not come perfect...

the formula what i used is

sum(NetCashFlowOperatingActivity)*(sum(Depreciation)/sum(ProfitBeforeTax)))/sum(NetCashFlowOperatingActivity)

Can anybody tell me where i made the mistake

[#2]

Hi,

There an extra "(" you need to omit...

you can use this code:

sum( NetCashFlowOperatingActivity )*(sum(Depreciation)/sum(ProfitBeforeTax))/sum(NetCashFlowOperatingActivity)

Or this: (I think this is much better)

sum( NetCashFlowOperatingActivity )* sum(Depreciation) / (sum(ProfitBeforeTax)* sum(NetCashFlowOperatingActivity))

Both Code has the same result.

Regards,

Nadsky

[#3]

Hi

but it's not give the accurate value as specified in the excel sheet

[#4]

Hi,

Can you send us the qvw file? Coz I noticed in your excel file that there are more than one column that has the same name that you also used in multiple sheets. Maybe this was the reason why we don't got an accurate value

[#5]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7536.Wt_5F00_Avg.xlsx:550:0]

Hi

I attached the sample Excel sheet

the profitbeforetax , Depreciation and Netcashflowoperatingactivity are given in the database as companywise as well as yearwise

I want to calculate the wt avg using the formula as

(netcashflowoperatingactivity*(Depreiation/Profitbeforetax))/netcashflowoperatingactivity

could you pls help me

[#6]

Hi,

I think this is the problem; noticed that there are 2 columns named ProfitBefore tax, also Depreciation and NetCashFlowOperatingActivity. Also noticed that these columns has different values to the other column (columns that have the same name).

Try to rename each colums like ProfitBeforeTaxX, DepreciationX, NetCashFlowOperationgActivityX and for the other column name it like ProfitBeforeTaxY and so on.

Also please remove the summation on each field coz Qlikview includes it in the computation.

Hope this one helps.

Regards,

Nadsky

[#7]

Hi

Profitbeforetax,depreciation,netcashflow are the fields there in table

I attached one more sample excel file.

Pls reply me

..[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/2450.Wt_5F00_Avg.xlsx:550:0]