Grouping Question 1

[ptrifile]

This is probably something stupidly simple but i just cannot wrap my arms around what the issue is. I have a report grouped by "TIMESTAMP" it is a DATETIME field. I am summing a field in a formula by group:

sum({wSkillsetStat.CallsAnswered}, {wSkillsetStat.Timestamp})

This works find and gives me the desired result...If I go into the Group Expert and go into options and change the "The section will be printed:" from "for each day" to "for each week" i get an error that says "There must be a group that matches this field and goes to the above formula. Am i missing something simple here? The grouping hasn't changed or moved anywhere.

Thanks for any help or suggestions.

Thanks!

Paul

 

[briangriffin]

Can't test right now, but try:

sum({wSkillsetStat.CallsAnswered}, {wSkillsetStat.Timestamp},"weekly")

If you create the summary field using the Summary function icon then the formulas change automatically when modifying the group this way. If you build the sum in the formula editor you have to manually modify the formula.

 

[ptrifile]

briangriffin, awesome! Thank you SO much! That worked perfectly!