# Big Numbers to show this month numbers **URL:** \ **Category:** Ask for Help\ **Created:** [April 3, 2024, 12:44am UTC](https://community.glideapps.com/t/big-numbers-to-show-this-month-numbers/72259 "2024-04-03T00:44:29Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Nazca\_Line\_Design](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nazca_line_design/32/66287_2.png) [@Nazca\_Line\_Design](https://community.glideapps.com/u/Nazca_Line_Design)\ **Post date:** [April 3, 2024, 12:44am UTC](https://community.glideapps.com/t/big-numbers-to-show-this-month-numbers/72259/1 "2024-04-03T00:44:29Z")
Hi, I am creating an expenses app, and I want the first page to show the sum of this month’s spending. Can I ask how I can do it, please? ---
**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 3, 2024, 2:03am UTC](https://community.glideapps.com/t/big-numbers-to-show-this-month-numbers/72259/2 "2024-04-03T02:03:06Z")
- Create a math column using the following formula: ```auto Year(Date) * 100 + Month(Date) ``` - Replace `Date` with the current date/time (Now) value - In your Spending table, create a similar math column, but replace `Date` with the date of the expense. - Create a Query column that targets you spending table, and filter where YearMonth (second math column) is This row-\>YearMonth (first math column) - Create a rollup column that targets the query column, and select sum. ---
**Author:** ![Nazca\_Line\_Design](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nazca_line_design/32/66287_2.png) [@Nazca\_Line\_Design](https://community.glideapps.com/u/Nazca_Line_Design)\ **Post date:** [April 4, 2024, 5:43am UTC](https://community.glideapps.com/t/big-numbers-to-show-this-month-numbers/72259/3 "2024-04-04T05:43:14Z")
Yes, I made it! Thanks a lot, Darren! ---
**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 4, 2024, 5:48am UTC](https://community.glideapps.com/t/big-numbers-to-show-this-month-numbers/72259/4 "2024-04-04T05:48:00Z")
oh, that’s my mistake, sorry. The math column returns a number, so the correct comparison operator in the Query column is “equals”. It should show up - can you show me a screen shot please? ---
**Author:** ![Nazca\_Line\_Design](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nazca_line_design/32/66287_2.png) [@Nazca\_Line\_Design](https://community.glideapps.com/u/Nazca_Line_Design)\ **Post date:** [April 4, 2024, 7:06am UTC](https://community.glideapps.com/t/big-numbers-to-show-this-month-numbers/72259/5 "2024-04-04T07:06:16Z")
A follow-up question, is it possible to create a chart to only show this month’s spending, please? As I found that the chart can’t show the data from the Query column, except numbers. ---
**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 4, 2024, 7:20am UTC](https://community.glideapps.com/t/big-numbers-to-show-this-month-numbers/72259/6 "2024-04-04T07:20:28Z")
Try setting your Spending table as the source of the Chart, and then use the math column as a filter (where the Spending row YearMonth equals the current YearMonth). ---
**Author:** ![Nazca\_Line\_Design](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nazca_line_design/32/66287_2.png) [@Nazca\_Line\_Design](https://community.glideapps.com/u/Nazca_Line_Design)\ **Post date:** [April 4, 2024, 4:27pm UTC](https://community.glideapps.com/t/big-numbers-to-show-this-month-numbers/72259/7 "2024-04-04T16:27:21Z")
Yes, got it! Thanks a lot! ---
**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 11, 2024, 4:28pm UTC](https://community.glideapps.com/t/big-numbers-to-show-this-month-numbers/72259/8 "2024-04-11T16:28:00Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.