# Calculated field for total value (currency) of entries based on a date field for each month

**URL:** <https://community.gravityforms.com/t/calculated-field-for-total-value-currency-of-entries-based-on-a-date-field-for-each-month/18117>\
**Category:** Get Help\
**Tags:** calculations, date-field\
**Created:** [September 2, 2024, 12:31pm UTC](https://community.gravityforms.com/t/calculated-field-for-total-value-currency-of-entries-based-on-a-date-field-for-each-month/18117 "2024-09-02T12:31:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![user60803f1e53ebc153](https://avatars.discourse-cdn.com/v4/letter/u/6de8d8/32.png) [@user60803f1e53ebc153](https://community.gravityforms.com/u/user60803f1e53ebc153)\
**Post date:** [September 2, 2024, 12:31pm UTC](https://community.gravityforms.com/t/calculated-field-for-total-value-currency-of-entries-based-on-a-date-field-for-each-month/18117/1 "2024-09-02T12:31:54Z")

</div>

I’m trying to get a calculation field to show and struggling with formula.

I have a date field and a number field, these represent a renewal date and a renewal cost.

I’m trying to get an additional field that will show total values for all entries within a set period.

The value I’m trying to get to is to show a value for January, February, March etc. with a total for every renewal in that particular month.

Can anyone point me in a direction as really struggling with this.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/gravityforms1/original/2X/f/fef63f0599c45e0218c30d9f5d7ca8bff9b00189.png) [@system](https://community.gravityforms.com/u/system)\
**Post date:** [October 2, 2024, 12:32pm UTC](https://community.gravityforms.com/t/calculated-field-for-total-value-currency-of-entries-based-on-a-date-field-for-each-month/18117/2 "2024-10-02T12:32:03Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.