I have the following graph:
I would like to calculate lapsed rate which is sum of lapsed value divided by sum of inforce value. I use the formula below in calculated field.
However this formula also pick the value from Q2 (quarter 2) 2016.
What I want ?
First check if any quarter does not contain both inforce value and lapsed value then skip that quarter.
In this case I need to calculate lapsed rate which does not include Q2 2016. Can someone help me on how can i do it?