i have this formula
if({Command.Job Requested}<> 0) then
if ({Command.GetWeekNo} = {?WeekNo} and {Command.GetYearNo} = {?YearNo}) then
count({Command.CompleteByDate},{Command.SectionDescription}) / sum({Command.Job Requested}, {Command.SectionDescription})
else 0
else 0
it's suppose to count all records where WeekNo and YearNo the user selects and divide with sum of everything in the database.
what i'm trying to get here is the percentage of what was done in the week the user select