Relating Records to A Common Variable Then Totaling those common records
I Have daily reports being created. Each report has various totals - we'll call one total MILES for my example.
I have people inputing into a daily record many variables every day. Each record now contains a field using GetAsNumber (date) to create the Week number that record is a part of.
So for Week 9 in my example (and all future weeks). How would I go about creating a formula that would relate to Miles and sum the miles fields for each week separately?