In a saved search, I have a formula that sums all time entries by employee: Formula (text): (sum/* comment */({durationdecimal}) OVER(PARTITION BY {employee} ORDER BY {employee} )) What I am trying to do is sum only specific types of time entries. For example, any time entry that appears in the 'leave' column So for example Employee Leave Other work Leave % Other Work % A 5 9 =(5+3)/(5+9+3+6) =(9+6)/(5+9+3+6) A 3 6 =(5+3)/(5+9+3+6) =(9+6)/(5+9+3+6) B 1 3 =1/(1+3) =3/(1+3) C 5 1 =5/(5+1) =1/(5+1) How do I specify a criteria in the 'over partition by' formula so that it only sums certain entries?