Page 2:
irrelevant raw data
Glide columns:
Date input (from date input from date picker) / template (year/month) / Relation on template with page 1 / Rollup - relation-positive numbers (sum of)
The rollup sum is showing correctly in the sheet but in the app it’s returning as 0.
What am i doing wrong of how do i fix this?
Only glide staff can view support links, so it’s not useful to the rest of us users.
I have suspicions with how you are working with the date. It may not be splitting the way you think it is on the front end. Date formats are very regional and can change depending on a user’s browser and device settings.
Instead of a split column and two single value columns, replace those three columns with two math columns.
First math column like this: YEAR(date)
Second math column like this: MONTH(date)
Then put the math year and month together with your template column.
