Skip to Content
0
Former Member
Sep 25, 2008 at 11:22 AM

help with the following formula

21 Views

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