Re: Filter sales this month.

980 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

This will be a long post, and a intricate task because Airtable somehow in 2023 doesn't have a "date is current month" type of filters.

I want to in my interface dashboard to summarize the total sales value within the current month. And in a statistics summary show the total sales pr month.

The rightmost box is is currently filtering the sales done within a month ago, which is not the correct setup.


When it's april, that one should only display April sales, not anything from March.

I have already a formula field that declares the date the sale was done, which is the field called "Salg".


What i need the formula to do is to return "1" or "true" if it's this month.

And then i will filter the summary to only calculate the sales value on the records which are a match to whatever value we create in the formula.... 


I appreciate any help i can get here.


2 Replies 2
6 - Interface Innovator
6 - Interface Innovator

Here's how I do it:




7 - App Architect
7 - App Architect

you can use this formula


IF( MONTH({Salg}) = MONTH(NOW()), 1,0 )

Rodolfo - RdMedia