Percentage

[syncdba]

I'm trying to find out the percentage of win of a particular ID ID WIN
--- ----
56 true Where true=WIN
56 false
56 true
56 true
10 false
10 false
10 true
10 true
10 false

Like for ID=56 true=3 Total=4 3/4*100 How can I filter by TRUE.

 

[synapsevampire]

One means would be to create a formula of:

//MyFormula
if {table.win} = true then
1
else
0

Now group by the ID, and in the group footer use a formula such as:

if count({table.win},{table.id}) > 0 then
(sum({@MyFormula},{table.id})/count({table.win},{table.id}))*100
else
0

-k