calculate percentage

[#1]

Hi

i am trying to calculate the percentage for all 4 networks like the table below , to sum all %success rate (10%+10%+33%+0%) and divide it by 4 ( number of networks)

Country	Network	Total Count Success	Total Count	%Success
Bulgaria	A	10	100	10%
Bulgaria	B	20	200	10%
Bulgaria	C	50	150	33%
Bulgaria	D	0	50	0%

Thanks.

[sunny_talwar]

May be like this:

Sum([%Success])/Count(DISTINCT Network)

[#3]

Hi Sunny

Thank you for you help with this issue ,

i try to use the Formula above , the "Count(DISTINCT Network)" give me the right number for example 3 networks but SUM of %success is not working , i am getting back a long number , the "%Success its something that i build as a variable in the  variable  overview , its seems that the SUM its not working , any idea why  ?

[#4]

Are you sure you want to sum all percentages. ideally u should avg them..

[#5]

Hi

i try avg but its the same like sum , looks like the qlikview ignore the function both of them

Gilad

[ThornOfCrowns]

OP is adding the figures then dividing by 4 to get an average

[#7]

Hi,

try this

=sum(%Success)/Count(DISTINCT Network)*100&'%'

[#8]

Hi

first , Thank  you all for your help but i am still having some issues with this.

i'll try to explain , this is what i am getting when i am check %success for each network

Country	Network	Count Success	Total count	%Success
Bulgaria	A	40	194	20.6%
Bulgaria	Bl	453	2089	21.7%
Bulgaria	C	108	402	26.9%

and this is when i remove the network Dimension

Country_AGG	Count Success	Count Total	Count network	%Success	Avg([%Success])	sum(%Success)/Count(DISTINCT Network_AGG)
Bulgaria	601	2685	3	22.4%	22.4%	241.96685288641

and this is what i would like to get - avg of 3 networks 23.1% like you see below , the number below is when i set "total mode" in qlikview UI to Average and i need it as a formula

Country	Network	Count Success	Total count	%Success
Bulgaria	A	40	194	20.6%
Bulgaria	B	453	2089	21.7%
Bulgaria	C	108	402	26.9%
				23.1%

Any idea ??

[sunny_talwar]

May be like this:

Avg(Aggr(Count(Success)/Count(TotalCount), Country, Network))

[#10]

Hi,

Find the attachment,

-Joyson G.