First time asking a question here, so please let me know if there's a better place to ask this question.
I have a report that shows how much I spent with Airbnb *this month*. I have check-in and check-out dates. In the report, I was filtering by Check-in This Month, and that worked fine if both dates are in the same month, but if not, that shows incorrect data. For example:
Check-in = Feb 29
Check-out = April 12
Based on the check in and check out dates, I want to be able to calculate how much I spent this current month, but I'm not sure how to calculate/ filter the report using the dates I currently have. I'm trying to see if there's any suggestions that do not involve super complicated formulas. Thanks!
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Unfortunately not. In order to do that, you would need another object related to the bookings.
You would need to create a record per month through a flow and do the calculation in the flow for each monthly record. You could then report on this new object instead, but there are some caveats:
You could end up consuming a lot of storage
The flow would be a bit tricky (but not impossible)
