I'm trying to calculate the gross annual revenue for the last year. But my filters seem wrong to me. I consider the interval between starting and final dates. But what if the date started in 2017, and ended in 2018? Then I need to calculate the income received from the beginning of 2018 until the final date. How to drop the "tail" of income from 2017? How do I fix my filters?

enter image description here

  • this won't be solvable with filters. You need to think about monthly revenue – cropredy May 7 '19 at 16:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.