# Sum for mounth **URL:** \ **Category:** Ask for Help\ **Created:** [March 15, 2023, 10:23pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220 "2023-03-15T22:23:37Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Gian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gian/32/53282_2.png) [@Gian](https://community.glideapps.com/u/Gian)\ **Post date:** [March 15, 2023, 10:23pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220/1 "2023-03-15T22:23:37Z")
Hi everyone, I need to report a summary of the sums per month, I managed to get them on the sheet but I don’t understand how to report them on the screen. I created a template but if I insert it in a rich text it displays 0.00 instead of the sum (I can’t recall the sum of a particular month). Thanks for the attention. ![Schermata 2023-03-15 alle 23.19.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/18cf0ef039d8742393ae155013a090b97bd890a6.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 16, 2023, 1:28am UTC](https://community.glideapps.com/t/sum-for-mounth/59220/2 "2023-03-16T01:28:46Z")
So do you need multiple months’ sums on the screen at once, or just the sum of current month? ---
**Author:** ![Gian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gian/32/53282_2.png) [@Gian](https://community.glideapps.com/u/Gian)\ **Post date:** [March 16, 2023, 1:26pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220/3 "2023-03-16T13:26:10Z")
Hi, thanks for your interest. I have already found the way to display the current month, now I would like to create various rich text with : “february total is …” for each month of the year. Thank you ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 16, 2023, 1:34pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220/4 "2023-03-16T13:34:54Z")
Have you tried using a template column? > **[Glide • Template Column](https://www.glideapps.com/docs/reference/computed-columns/template-column)** > > Display dynamic text that can change with the values in other columns. ---
**Author:** ![Gian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gian/32/53282_2.png) [@Gian](https://community.glideapps.com/u/Gian)\ **Post date:** [March 16, 2023, 1:51pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220/5 "2023-03-16T13:51:07Z")
![Schermata 2023-03-16 alle 14.50.22](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/64aaf87898d7e38c35e14d268ca389fbcbe250dc.jpeg) ![Schermata 2023-03-16 alle 14.50.32](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6538cdc003da442816badc1e9cd065bf87b2147.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 16, 2023, 2:48pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220/6 "2023-03-16T14:48:07Z")
Does your relation link to a table that uses Row Owners? My guess is that the total is zero because when you view the app, it does not have access to the unowned rows you are trying to sum. It might help if you explain where those numbers are coming from. The only other thought is that you are viewing a row that actually has a sum of zero. Hard to tell though. ---
**Author:** ![Gian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gian/32/53282_2.png) [@Gian](https://community.glideapps.com/u/Gian)\ **Post date:** [March 16, 2023, 8:47pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220/7 "2023-03-16T20:47:12Z")
The Table has Id Row, in fact on the table it works correctly, I think the problem is how to “tell” that I want to display the total of a given month, therefore, the problem is how to say which result it should display? ---
**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\ **Post date:** [March 16, 2023, 10:11pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220/8 "2023-03-16T22:11:05Z")
Ciao @Gian, ti conviene creare una nuova tabella (chiamala ad esempio Dashboard) con dei parametri fissi, con una colonna chiamata “Mesi” e li inserisci 12 righe, uno per ogni mese, da Gen a Feb. Poi crei una colonna multi relation tra il mese di questa tabella e la colonna mese dell’altra tabella. Fatto ciò aggiungi una colonna rollup che ti darà la somma per ogni mese sulla tabella Dashboard. ---
**Author:** ![Gian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gian/32/53282_2.png) [@Gian](https://community.glideapps.com/u/Gian)\ **Post date:** [March 17, 2023, 11:24am UTC](https://community.glideapps.com/t/sum-for-mounth/59220/9 "2023-03-17T11:24:44Z")
Grazie @Antonino_Nolasco ho fatto come mi hai detto ma non mi funziona la relazione, ti invio schermata, la colonna da me chiamata Mesex è un format date che prende la data di inserimento e me la formatta nel nome del mese. Cosa mi sono perso? ![Schermata 2023-03-17 alle 12.22.20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5a08de0cb59c191ef558343b4a663888baef8e32.jpeg) ---
**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\ **Post date:** [March 17, 2023, 11:27am UTC](https://community.glideapps.com/t/sum-for-mounth/59220/10 "2023-03-17T11:27:38Z")
Ciao @Gian, non devi creare nessuna colonna format, basta creare una colona di testo e crei 12 righe chiamate ognuna con il mese di riferimento. ---
**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\ **Post date:** [March 17, 2023, 11:33am UTC](https://community.glideapps.com/t/sum-for-mounth/59220/11 "2023-03-17T11:33:12Z")
Scusami, ho visto bene adesso lo screenshot. Allora, invece di creare una colonna format nell’altra tabella, crea una colonna IF-THEN-ELSE come da immagine allegata. Infine esegui la relazione con questa colonna. Nel mio caso la colonna MESE è una colonna di tipo MATH con la seguente formula: MONTH(Data). Dove Data è la tua colonna in cui vai a prendere il riferimento del mese. ![Immagine 2023-03-17 123210](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1abf109ab8a117d8d0b313cbcfc61d9062d9d295.png) ---
**Author:** ![Gian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gian/32/53282_2.png) [@Gian](https://community.glideapps.com/u/Gian)\ **Post date:** [March 17, 2023, 10:00pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220/12 "2023-03-17T22:00:39Z")
@Antonino_Nolasco Grazie, finalmente il problema è risolto! ---
**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:** [March 18, 2023, 10:01pm UTC](https://community.glideapps.com/t/sum-for-mounth/59220/13 "2023-03-18T22:01:20Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.