Date, RollUp and condionnal statement

Topic Labels: Formulas
551 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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