Help with formula

[ivandrago]

Hi,

I have the following formula:

(([Resolved]-[Exceptions])/[Resolved])

how do I change this so that it only shows where the following field IsServ = 1

Thanks

[#2]

if(IsServ=1,([Resolved]-[Exceptions])/[Resolved]))

[ivandrago]

No not working

[lucas4bi]

Are these fields all in the same table?

If so try with sum(if(isServ=1,( (([Resolved]-[Exceptions])/[Resolved])))

[#5 · Accepted solution]

=if(IsServ=1,(Resolved-Exceptions)/Resolved))

And this one?

What is the exception you get?