# Calculated fields in reports are not working correctly

**URL:** https://forum.mautic.org/t/calculated-fields-in-reports-are-not-working-correctly/35575
**Category:** Product Support
**Created:** [April 27, 2025, 9:12pm UTC](https://forum.mautic.org/t/calculated-fields-in-reports-are-not-working-correctly/35575 "2025-04-27T21:12:05Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![zaharovrd](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/zaharovrd/32/7799_2.png) [@zaharovrd](https://forum.mautic.org/u/zaharovrd)
#### Post date: [April 27, 2025, 9:12pm UTC](https://forum.mautic.org/t/calculated-fields-in-reports-are-not-working-correctly/35575/1 "2025-04-27T21:12:05Z")

</div>

**Your software**  
My Mautic version is:  
My PHP version is:  
My Database type and version is:

**Your problem**  
My problem is:  
There are 2 mautic installations  
v5.1.1 and v4.4.10  
In v5.1.1 an email report was created with the following columns:

 ![2025-04-28_00-01](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/5/5c23d8335e1acdc87cf8a11241945e6e6dd2634e.png)  
Calculated columns are counted correctly for trigger emails sent from campaigns

But if i look at segment email’s

 ![2025-04-28_00-03](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/5/57ef304be22afd617b26ba307d5281557ba50bc5.png)  
they are many times larger than the actual values - it is not clear what is counted.

Now the funniest thing is that when I tried to customize the same report on v4.4.10 I got the opposite situation. 🤣

By the way, why don’t you just output the sum of the total table at the bottom, even without calculated fields. The Totals row is always there, even when there are no calculated fields.

Where can I find the report settings? How can I customize them or change the logic of operation?

---

<div class="post-metadata">

### Author: ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [April 28, 2025, 4:30am UTC](https://forum.mautic.org/t/calculated-fields-in-reports-are-not-working-correctly/35575/2 "2025-04-28T04:30:23Z")

</div>

Hi, you can click on the DATA tab when you EDIT a report. Your problem is, that you are grouping wrong in the example.  
Once you share the content under the DATA tab, I’ll be able to help you.

---

<div class="post-metadata">

### Author: ![zaharovrd](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/zaharovrd/32/7799_2.png) [@zaharovrd](https://forum.mautic.org/u/zaharovrd)
#### Post date: [April 28, 2025, 7:35am UTC](https://forum.mautic.org/t/calculated-fields-in-reports-are-not-working-correctly/35575/3 "2025-04-28T07:35:59Z")

</div>

![screenshot-2025-04-28-10-34](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/6/6700558f0711bba3fac335772306c8b34012bfee.png)

I am grouping ID  
And why do you need a grouping to calculate the fields?

---

<div class="post-metadata">

### Author: ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [April 28, 2025, 7:57am UTC](https://forum.mautic.org/t/calculated-fields-in-reports-are-not-working-correctly/35575/4 "2025-04-28T07:57:57Z")

</div>

Okay, good.

What is your report timeframe?  
That is visible here:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/6/66378695fa51187d8ebded64e35ddf1d58a91cf3.png)

Your report will contain only contacts added during this timeframe.  
Not events happened (sends) during this timeframe, but contacts added to Mautic.

---

<div class="post-metadata">

### Author: ![zaharovrd](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/zaharovrd/32/7799_2.png) [@zaharovrd](https://forum.mautic.org/u/zaharovrd)
#### Post date: [April 28, 2025, 12:39pm UTC](https://forum.mautic.org/t/calculated-fields-in-reports-are-not-working-correctly/35575/5 "2025-04-28T12:39:27Z")

</div>

I’m building a report on sent letters? Without a group, the calculated fields do not appear (  
The values ​​of the calculated more than the same are more than the same, but not calculated.

 ![2025-04-28_15-38](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/c/c4b1f7cfcf8cc8b8a038ba520c04688d4a5e9aa3.png)  
Time for the entire period of work Mautic

It makes no difference what you take the period - in version 5 - for segment mailings, the calculated values ​​are multiple more, and at 4 were for trigger)

i’m do not have 252340 send email…  
4558 - is true number

---

<div class="post-metadata">

### Author: ![zaharovrd](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/zaharovrd/32/7799_2.png) [@zaharovrd](https://forum.mautic.org/u/zaharovrd)
#### Post date: [April 29, 2025, 7:56am UTC](https://forum.mautic.org/t/calculated-fields-in-reports-are-not-working-correctly/35575/6 "2025-04-29T07:56:35Z")

</div>

I think that by grouping by ID the sum of all ID contacts presented as the number …
