Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Group Conditionis not Known Post Reply Post New Topic
Author Message
hancorn
Newbie
Newbie
Avatar

Joined: 10 Mar 2009
Online Status: Offline
Posts: 9
Quote hancorn Replybullet Topic: Group Conditionis not Known
    Posted: 10 Mar 2009 at 8:05am
Hi,
 
Wondering if anyone can help me.
 
I am modifying a report that someone else wrote and it basically returns an average elapsed time for a month based on how quickly agents close tickets.
 
I know have to modify this for a weekly stat but when I modify the formula field to include "weekly" it scomes back saying that the "The group condition is not known"
 
Here is the formula field pre editing - Round(Average ({@Elapsed Days}, {@dtCompleted}, "monthly"),2)
 
post edit - Round(Average ({@Elapsed Days}, {@dtCompleted}, "weekly"),2) 
 
Can anyone tell me why I cant use "weekly" or is my syntax wrong?
 
Thanks
Sean
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Mar 2009 at 7:12am
The Average function is computing the average of the data based on the grouping called 'monthly' in the report.  If you check the GH sections of the report one is called 'monthly'.  Not knowing the report, it may be a data field, but is probably formula.  If is a formula, you can modify the logic in it to make the report work as desired.  If you want monthly and weekly, you will probably want to create a new grouping that will work correctly.
 
Hope this helps
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.