# Calculated field to count referrees

**URL:** <https://community.brevo.com/t/calculated-field-to-count-referrees/2320>\
**Category:** Contacts\
**Created:** [Octobre 17, 2024, 8:17 UTC](https://community.brevo.com/t/calculated-field-to-count-referrees/2320 "2024-10-17T08:17:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sal\_media](https://dub1.discourse-cdn.com/flex013/user_avatar/community.brevo.com/sal_media/32/827_2.png) [@sal\_media](https://community.brevo.com/u/sal_media)\
**Post date:** [Octobre 17, 2024, 8:17 UTC](https://community.brevo.com/t/calculated-field-to-count-referrees/2320/1 "2024-10-17T08:17:43Z")

</div>

Hello,

I would like to add a calculated field in my Brevo contact database.

Each customer has a referral code and can refer friends.

I would like to count, for each contact, the number of referrals who have registered.

Today, in my database, I have :

- email
- referral code
- referral reference (the one through whom we arrived)

How can I count the number of contacts who have the contact’s «&nbsp;referral code&nbsp;» as their «&nbsp;referral reference&nbsp;»?

Thank you very much  
S.

---

<div class="post-metadata">

**Author:** ![ahudavert](https://dub1.discourse-cdn.com/flex013/user_avatar/community.brevo.com/ahudavert/32/14_2.png) [@ahudavert](https://community.brevo.com/u/ahudavert)\
**Post date:** [Octobre 18, 2024, 2:50 UTC](https://community.brevo.com/t/calculated-field-to-count-referrees/2320/2 "2024-10-18T14:50:57Z")

</div>

Hi @sal_media ,

I checked this article: [https://help.brevo.com/hc/en-us/articles/209558545-Build-and-use-formulas](https://help.brevo.com/hc/en-us/articles/209558545-Build-and-use-formulas) and I did not find anything related to your request.

Still, I see two workarounds for you:

- either you download the data and you can use Excel formulas: this has the drawback that it’s not updated live, of course
- you can create a segment that will look for all contacts who have referral code = XXX  
You can create a segment per referral code value; I don’t know how many values there are, so maybe it’s a bit time consuming, but once created, segments will be updated live

what do you think?

---

<div class="post-metadata">

**Author:** ![sal\_media](https://dub1.discourse-cdn.com/flex013/user_avatar/community.brevo.com/sal_media/32/827_2.png) [@sal\_media](https://community.brevo.com/u/sal_media)\
**Post date:** [Octobre 20, 2024, 11:23 UTC](https://community.brevo.com/t/calculated-field-to-count-referrees/2320/3 "2024-10-20T11:23:36Z")

</div>

Bonjour,

(Je bascule en français, plus facile pour moi, et j’ai cru comprendre que vous étiez également francophone sur votre profil.)

Je n’imagine pas gérer cela en exports / imports excel ; cela serait trop fastidieux au vu de la fréquence d’envoi de la newsetter (2x par semaine).

De même pour le fait de créer un segment par parrain ; cela ne me paraît pas tenable avec l’augmentation de la base à venir.

Aujourd’hui, dans mes contacts, chacun a :

- un code de parrainage (pour parrainer).
- le code du parrain par lequel il s’est abonné.

Sur mes newsletters, je dois pouvoir écrire de manière dynamique «&nbsp;merci, vous avez parrainé X personnes&nbsp;», car un système de récompenses y sera lié.

J’ai cru comprendre que le principe des champs calculés est de pouvoir appliquer des formules ; est-ce que ces champs custom seraient utilisables pour ce besoin ?

merci beaucoup

---

<div class="post-metadata">

**Author:** ![ahudavert](https://dub1.discourse-cdn.com/flex013/user_avatar/community.brevo.com/ahudavert/32/14_2.png) [@ahudavert](https://community.brevo.com/u/ahudavert)\
**Post date:** [Octobre 24, 2024, 1:30 UTC](https://community.brevo.com/t/calculated-field-to-count-referrees/2320/4 "2024-10-24T13:30:55Z")

</div>

Bonjour,

Merci pour ces détails. J’ai regardé l’article dont j’ai mis le lien au-dessus, et malheureusement je n’ai pas trouvé de façon simple de le faire.

Je ne sais pas si de votre côté vous avez trouvé une solution en lisant cet article ?