AnsweredAssumed Answered

Calculated field that would sum dollar amounts within a specified date range.

Question asked by PhilCornish on Nov 13, 2012
Latest reply on Nov 14, 2012 by PhilCornish

Title

Calculated field that would sum dollar amounts within a specified date range.

Post

     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.

Outcomes