Joined: 03 Nov 2010
Location: United States
Online Status: Offline
Posts: 3
Topic: average and percetange Posted: 03 Nov 2010 at 11:36am
Hello,
I'm new at using crystal reports and i'm trying to find out a simple way to do the following report that will group the category and give me a average for month and YTD and also average and percentage for both: MANY THANKS!
Joined: 03 Nov 2010
Location: United States
Online Status: Offline
Posts: 3
Posted: 04 Nov 2010 at 5:59am
if {Inspections_and_Tests.LU_InspectionCat~Description} = "Audit" then ({Inspections_and_Tests.InspectionsTests~InspectionDate})In Date(Year(CurrentDate), Month(CurrentDate),1) To DateAdd("m",1,Date(Year(CurrentDate), Month(CurrentDate),1)-1); If {@sys.PossiblePoints}=0 then 0 else ({@sys.AwardedPoints}/{@sys.PossiblePoints})*100
this is the formula that i'm using but is not giving me the reult i need :(
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
and i'm trying to find out a simple way to do the following report that will group the category and give me a average for month and YTD and also average and percentage for both: MANY THANKS! 
IP Logged