Error - There must be a group that matches this field

[rsunra]

I get the follow error:

"There must be a group that matches this field"

What does it mean

on the Sum({Duration}, {@DayofWeek});


numbervar dur:= Sum({Duration}, {@DayofWeek});

numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

hhmmss := totext(hrs, "0") + ":" + totext(min, "00") + ":" + totext(sec, "00");

@dayofweek = WeekdayName (DayOfWeek ({FIN03_Main.Event_Date}))

 

[Turkbear]

Hi,
You are asking Crystal to sum the value of Duration for each result of the formula {@DayofWeek}- but that requires that the same formula be used as a Group -

As I understand it, the syntax
Sum({Duration}, {@DayofWeek})
means to sum the values for Duration every time the Group based on the {@DayofWeek}formula changes value..