So far a big fan of the product, however I am a bit puzzled how to tackle this problem.
I have a customer list which are either ‘active’ or ‘in-active’; based on their plan.
I would like to make an overview which automatically calculated the monthly recurring revenue from people with an active plan. Currently I set manually the active & in-active date.
So my logic was as followed:
January 2021: IF ‘month= 01’ & ‘year= 2021’ is WITHIN ‘active date’ AND ‘in-active date’ THEN SUM ‘Monthly recurring revenue’
To add would like to have also a list of the amount of active customers:
January 2021: IF ‘month= 01’ & ‘year= 2021’ is WITHIN ‘active date’ AND ‘in-active date’ THEN COUNT ‘Customers’
As I am not an experienced Airtable user; would like to know if someone can help me. Since tried a few things; but I seem not to find my way