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.
