Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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