Finding percentage when a condition is met

Hi All,

I am looking to find the percentage of when something is predicted and comes true over when it only comes true.

I have attached an excel sheet which might help.

To make things slightly harder. i would like to have the percentage only calculated over a range which is varied by filters on other columns.

Thanks for your help,

Adam