Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Date, RollUp and condionnal statement

Topic Labels: Formulas
234 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello All,

Sorry if this is an easy question, but I looked some of the articles and I am totally lost ^^

I have a table 1 like this listing my subscriptions

  • internal code
  • date of the subscription starting
  • date of the subscription ending
  • mensual fees

Capture d’écran 2020-11-13 à 18.22.13

I want next a view or a table or an app aggregating by month my revenues !

What seems to me the easiest way was to create a Table 2 like this :

  • month
  • internal code linked to table 1
  • subscriptions start dates
  • subscriptions end start
  • rollup fields summing the mensual fees

And I am looking for a way to show in the “internal code” field only the one where “month” is between start date and end date.

I have not found a way to do this ? I am lost :frowning:

Capture d’écran 2020-11-13 à 18.25.59

0 Replies 0