Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sacha
Contributor
Contributor
‎2020-08-27 09:11 AM

Annual Recurring Revenue formula

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,

 

 

 

 

 

 

 

771 Views
0 Likes
0 Replies