Dear Qlik Community,
I'm trying to calculate the churn ARR for my premium customer. I already have a formula but I have a value of 0 in euros while I had 8 terminations
Here is my formula :
count(aggr(if(year(date_cancelled) = year(today()-1) and day(date_cancelled) <= day(today()-1) and month(date_cancelled) = month(today()-1) and plan_type = 'premium' and Count(optin.date_created)>=3 ,1)
,[FID_shop_id-shop_id]*12*5))/1000
Do you have an idea of the problem?
Thank you in advance for your help!
Regards,
