AnsweredAssumed Answered

Relating Records to A Common Variable Then Totaling those common records

Question asked by Lex262 on Oct 10, 2008
Latest reply on Oct 10, 2008 by TSGal

Title

Relating Records to A Common Variable Then Totaling those common records

Post

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?

 

 

Outcomes