Calculated field that would sum dollar amounts within a specified date range.
We are looking to set up a calculated field that would sum the amounts (see picture) within a specified date range. In this case we are looking for it to sum the amounts after the year 2010, which in this example would equal $20. However, we’d like to be able to change the date parameters in the future. Assuming we could do that relatively easy once the initial operation/calculation is set up.
We’d prefer to have this calculation field rather than get the same results via a search/find operation because we’d like to be able to output the dollar amount for further analysis. Not sure if that makes sense or not...hope so!
Thanks in advance for any help.