Help

Re: Filter sales this month.

980 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ruben_Rossvold
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.

Ruben_Rossvold_0-1681997933278.png

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".

Ruben_Rossvold_1-1681998226053.png

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
FlywheelConsult
6 - Interface Innovator
6 - Interface Innovator

Here's how I do it:

 

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

 

RdMedia_srl
7 - App Architect
7 - App Architect

you can use this formula

 

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

Rodolfo - RdMedia