# Can anyone make Personel Budget Template? **URL:** \ **Category:** Ask the Community\ **Created:** [September 16, 2019, 12:41pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625 "2019-09-16T12:41:25Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Aykut\_OZYAYIKCI](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aykut_ozyayikci/32/9518_2.png) [@Aykut\_OZYAYIKCI](https://connect.superhuman.com/u/Aykut_OZYAYIKCI)\ **Post date:** [September 16, 2019, 12:41pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/1 "2019-09-16T12:41:25Z")
I will try different formulas or templates but can’t make it! Anyone make a personal budget template? ---
**Author:** ![Aykut\_OZYAYIKCI](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aykut_ozyayikci/32/9518_2.png) [@Aykut\_OZYAYIKCI](https://connect.superhuman.com/u/Aykut_OZYAYIKCI)\ **Post date:** [September 16, 2019, 3:48pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/2 "2019-09-16T15:48:17Z")
Thanks @jean_pierre_traets ---
**Author:** ![Jean\_Pierre\_Traets](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_pierre_traets/32/16275_2.png) [@Jean\_Pierre\_Traets](https://connect.superhuman.com/u/Jean_Pierre_Traets)\ **Post date:** [September 16, 2019, 5:56pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/3 "2019-09-16T17:56:22Z")
Dear @Aykut_OZYAYIKCI, Your question is quite general on the personal budget template. As I understand you checked the templates and that what’s available in the community, but it doesn’t meet your expectations. Just with respect for the community members time, please try to take care of the following: Take at least the nearest option and try to explain what you want to see in a different way, or the formula you can’t get your head around. I have seen people even make a drawing or screenshot from what they have seen somewhere. Don’t give up, your journey just started and you will learn some interesting things on the way 🤝 ---
**Author:** ![Aykut\_OZYAYIKCI](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aykut_ozyayikci/32/9518_2.png) [@Aykut\_OZYAYIKCI](https://connect.superhuman.com/u/Aykut_OZYAYIKCI)\ **Post date:** [September 17, 2019, 11:59am UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/4 "2019-09-17T11:59:47Z")
I will try thanks @Jean_Pierre_Traets 👍👍👍👍 ---
**Author:** ![Aykut\_OZYAYIKCI](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aykut_ozyayikci/32/9518_2.png) [@Aykut\_OZYAYIKCI](https://connect.superhuman.com/u/Aykut_OZYAYIKCI)\ **Post date:** [September 24, 2019, 1:08pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/5 "2019-09-24T13:08:49Z")
I make this template https://coda.io/embed/QVflBTCGa1/_suZJ5?viewMode=embedplay But can’t make total “MONTHLY” in summary page Can anybody help for formulas? ---
**Author:** ![Saul\_MIND\_Garcia](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/saul_mind_garcia/32/3565_2.png) [@Saul\_MIND\_Garcia](https://connect.superhuman.com/u/Saul_MIND_Garcia)\ **Post date:** [September 24, 2019, 1:41pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/6 "2019-09-24T13:41:14Z")
Not sure if you can see the change I made in your Coda but I’ll leave de formula here: [Income-Expenses].Filter([Income- Expenses]=“Expense” and Date.MonthName()=Month and Date.Year()=2019).Total.Sum() First you need to filter your table by Expense and then you have to match the month name, you have to do Date.MonthName() so it will give you a Text then you can compare it with you Month control so they both match, then you have to match the Year, I harcoded the 2019 in the formula but I recommend using a control so you can change it at will. Lastly, of all the rows that match your filter, you get the Total and make a sum of them all. ---
**Author:** ![Aykut\_OZYAYIKCI](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aykut_ozyayikci/32/9518_2.png) [@Aykut\_OZYAYIKCI](https://connect.superhuman.com/u/Aykut_OZYAYIKCI)\ **Post date:** [September 24, 2019, 3:31pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/7 "2019-09-24T15:31:29Z")
Dear @Saul_MIND_Garcia Can you make example? I can make TOTAL 2019 EXPENSE But I can understand MONTH or Date.MonthName()=Month formula? Thanks for your interest ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [September 24, 2019, 5:01pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/8 "2019-09-24T17:01:46Z")
“Corrected” it for you (I think 🤔 ) 😉 `[Income-Expenses].Filter([Income- Expenses]="Expense" AND Date.MonthName()=Month.Months AND Date.Year()="2019").Total.Sum()` The part : `.Months` was missing in this part -\> `Date.MonthName()=Month` which compares “a text” to another “text”. But because `.Months` was missing, it couldn’t do “the comparison” (well it wasn’t comparing the same things) so it couldn’t do the math 😉 ---
**Author:** ![Saul\_MIND\_Garcia](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/saul_mind_garcia/32/3565_2.png) [@Saul\_MIND\_Garcia](https://connect.superhuman.com/u/Saul_MIND_Garcia)\ **Post date:** [September 24, 2019, 5:08pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/9 "2019-09-24T17:08:18Z")
Sure! I made and example with all the explanation: https://coda.io/embed/5v5VYZnXM_/_suBCQ?viewMode=embedplay ---
**Author:** ![Aykut\_OZYAYIKCI](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aykut_ozyayikci/32/9518_2.png) [@Aykut\_OZYAYIKCI](https://connect.superhuman.com/u/Aykut_OZYAYIKCI)\ **Post date:** [September 24, 2019, 7:37pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/10 "2019-09-24T19:37:13Z")
Many many thanks @Saul_MIND_Garcia I applied formulas to my table but does not receive monthly expense sum i think something wrong i was trying to solve your table is wonderful i also applied it to my own table Thanks Again ---
**Author:** ![Saul\_MIND\_Garcia](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/saul_mind_garcia/32/3565_2.png) [@Saul\_MIND\_Garcia](https://connect.superhuman.com/u/Saul_MIND_Garcia)\ **Post date:** [September 24, 2019, 8:12pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/11 "2019-09-24T20:12:58Z")
You’re welcome Aykut! I’m glad you liked it! For the formulas I made, the control to pick the month has to be a Control\>Select filled with the values of the Months Table and the Month column [Months].Month ![Month%20Control](https://global.discourse-cdn.com/coda1/original/2X/0/0db5b40c92954b34e4612d10253747815095adcd.png) I made the changes to your doc so it now works, the problem was that you were using a datepicker to select the month, I changed it as I explained above and it worked. ---
**Author:** ![Aykut\_OZYAYIKCI](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aykut_ozyayikci/32/9518_2.png) [@Aykut\_OZYAYIKCI](https://connect.superhuman.com/u/Aykut_OZYAYIKCI)\ **Post date:** [September 25, 2019, 2:47pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/12 "2019-09-25T14:47:13Z")
Dear @Saul_MIND_Garcia Thank you again but you’ll see my table TOTAL SEPTEMBER EXPENSE is 0 I couldn’t understand 🤣🤣🤣🤣 Can you explain? I missed anything? ---
**Author:** ![Saul\_MIND\_Garcia](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/saul_mind_garcia/32/3565_2.png) [@Saul\_MIND\_Garcia](https://connect.superhuman.com/u/Saul_MIND_Garcia)\ **Post date:** [September 25, 2019, 3:11pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/13 "2019-09-25T15:11:48Z")
The problem with your approach is that you are using a datepicker to select a month, the datepicker gives you a date (even if it is just showing the month), when you try to filter a table so it is equal to your date it will try to look for all the entries that match that date. For it to work you have to get the month of both the date of the entry and the datepicker, you do that by adding a .Month() to both of them to compare them in the filter. Check this copy of your document, I leave 2 ways of doing what you want. https://coda.io/embed/OGjMA3pGNF/_suZJ5?viewMode=embedplay ---
**Author:** ![Aykut\_OZYAYIKCI](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/aykut_ozyayikci/32/9518_2.png) [@Aykut\_OZYAYIKCI](https://connect.superhuman.com/u/Aykut_OZYAYIKCI)\ **Post date:** [September 25, 2019, 3:16pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/14 "2019-09-25T15:16:17Z")
@Saul_MIND_Garcia Yeah I see thanks 👍👍👍👍 ---
**Author:** ![Harley\_Vargas](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/harley_vargas/32/21601_2.png) [@Harley\_Vargas](https://connect.superhuman.com/u/Harley_Vargas)\ **Post date:** [October 15, 2021, 10:15pm UTC](https://connect.superhuman.com/t/can-anyone-make-personel-budget-template/10625/15 "2021-10-15T22:15:23Z")
Thank you very much for that formula you share @Saul_MIND_Garcia but how can you change my currency?