# Colonne calculée selon criteres

**URL:** <https://community.glideapps.com/t/colonne-calculee-selon-criteres/60490>\
**Category:** Ask for Help\
**Created:** [April 13, 2023, 3:26pm UTC](https://community.glideapps.com/t/colonne-calculee-selon-criteres/60490 "2023-04-13T15:26:32Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![DACC\_CHANTENAY](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dacc_chantenay/32/57527_2.png) [@DACC\_CHANTENAY](https://community.glideapps.com/u/DACC_CHANTENAY)\
**Post date:** [April 13, 2023, 3:26pm UTC](https://community.glideapps.com/t/colonne-calculee-selon-criteres/60490/1 "2023-04-13T15:26:32Z")

</div>

Bonjour a tous,

Je souhaiterais créer une colonne calculée de ma colonne" Quel encart?" en fonction des critères  
Total des 40€  
Total des 60€  
Total des 80€  
Total des120€

 ![Capture d’écran 2023-04-13 à 17.18.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d7538ac1d7f4d6cfd78dea9215184c72eb972af3.png)  
Est-ce possible, merci  
Je suis novice, merci  
Laurent

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [April 13, 2023, 3:33pm UTC](https://community.glideapps.com/t/colonne-calculee-selon-criteres/60490/2 "2023-04-13T15:33:31Z")

</div>

Hello and welcome to the community 🥳

Crete a new table with four rows 40,60,80,120

Create a MULTIPLE relation from amounts in new table to your amounts in Quel encart

Create a New Column → Rollup → Summarize the value of: → your relation Quel encart

By calculating the: Count

---

<div class="post-metadata">

**Author:** ![DACC\_CHANTENAY](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dacc_chantenay/32/57527_2.png) [@DACC\_CHANTENAY](https://community.glideapps.com/u/DACC_CHANTENAY)\
**Post date:** [April 13, 2023, 3:45pm UTC](https://community.glideapps.com/t/colonne-calculee-selon-criteres/60490/3 "2023-04-13T15:45:00Z")

</div>

Bonjour Eric,  
Merci de votre aide, j’ai testé mais pas bon  
Soit j’ai pas compris ou mal expliqué  
Ce que je souhaite c’est avoir le total de chaque somme soit  
40€ = 3  
60€= 2  
80€= 2  
120€= 2

 ![Capture d’écran 2023-04-13 à 17.40.52](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/47758cd7377f6906afa94671944f6b77543ec832.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 13, 2023, 3:50pm UTC](https://community.glideapps.com/t/colonne-calculee-selon-criteres/60490/4 "2023-04-13T15:50:24Z")

</div>

Create a multiple relation column that matches that column with itself, then do a rollup-\>count via the relation.

---

<div class="post-metadata">

**Author:** ![DACC\_CHANTENAY](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dacc_chantenay/32/57527_2.png) [@DACC\_CHANTENAY](https://community.glideapps.com/u/DACC_CHANTENAY)\
**Post date:** [April 13, 2023, 4:09pm UTC](https://community.glideapps.com/t/colonne-calculee-selon-criteres/60490/6 "2023-04-13T16:09:50Z")

</div>

Merci beaucoup pour la solution

---

<div class="post-metadata">

**Author:** ![DACC\_CHANTENAY](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dacc_chantenay/32/57527_2.png) [@DACC\_CHANTENAY](https://community.glideapps.com/u/DACC_CHANTENAY)\
**Post date:** [April 13, 2023, 4:10pm UTC](https://community.glideapps.com/t/colonne-calculee-selon-criteres/60490/7 "2023-04-13T16:10:23Z")

</div>

Merci beaucoup pour la solution, je continue

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 14, 2023, 4:10pm UTC](https://community.glideapps.com/t/colonne-calculee-selon-criteres/60490/8 "2023-04-14T16:10:58Z")

</div>

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