how to find average percentage of individual person sales?

[krishna789]

ex:

salesperson   iswon     is lost

krishna           2               1

jhon                2                0

dany                1                 2

ramu                  2                2

key                    3                     0

if i select sales person in list box  i should get highest wins and lowest win percentage of individual person.

pls make qvw and share it would more helpfull.pls try and share

thanks

krishna

[Kushal_Chawda]

Can you just tell me what could be the highest and lowest % win if I select the Krishna

[krishna789]

highest win rate =iswon/(iswon+islost)

lowest win rate =islost/(iswon+islost)

[Kushal_Chawda]

Create two text object for highest & lowest win

='Highest Win Rate : '&num(sum(iswon)/sum(iswon+[is lost]),'#0.0%')

='Lowest Win Rate : '&num(sum([is lost])/sum(iswon+[is lost]),'#0.0%')

[its_anandrjs]

Try this ways and see the attached also

highest win rate  =sum(iswon)/sum(TOTAL iswon) + sum(TOTAL [is lost])

lowest win rate  =sum([is lost])/sum(TOTAL iswon) + sum(TOTAL [is lost])

[krishna789]

once check this how i want answer

higest win =(1/3)*100=33.33%

Anand Chouhan wrote:

Try this ways and see the attached also

highest win rate  =sum(iswon)/sum(TOTAL iswon) + sum(TOTAL [is lost])

lowest win rate  =sum([is lost])/sum(TOTAL iswon) + sum(TOTAL [is lost])

9_1541

[its_anandrjs]

33.33 % is for single person Krishna.

[its_anandrjs]

Ok then try this ways see attached also

[#9]

Try this

for loss percentage

num(Sum([is lost])/(Sum(iswon)+Sum([is lost])),'##.##%')

for win Percentage

num(Sum(iswon)/(Sum(iswon)+Sum([is lost])),'##.##%')