Retention Calculation

[thomas_2583]

Hi, 

I have a calculation whereby I calculate the number of people that have cancelled their subscription. 

What I am looking for is to flip it, so the number displayed is a % of customers that have stayed.

The calculation below gives me 24% which is the % of customers that have cancelled. 

count({<Prod_Z={'Y'},Can_Months={'<2'}>}Count_Flag)
/
count({<Prod_Z={'Y'}>}Count_Flag)

What I would like to see if 76% as my output to show the % value of customers that have stayed. 

Any idea how I can flip this please?

[MayilVahanan · Accepted solution]

Hi @thomas_2583 

Try like this

1- (count({<Prod_Z={'Y'},Can_Months={'<2'}>}Count_Flag)
/
count({<Prod_Z={'Y'}>}Count_Flag))

Hope it helps