G
gumby
ResponseRateI: Sum(Abs([StatusIr]="Objective Meet"))/Sum(Abs(Not
[StatusIr]="No Objective Required"))
Sometimes in my query I get a #Error message. Of course I know why, it
cannot divide by zero. I would like to handle this error buy placing a
1 in the field is the an #error is returned.
I have tried
IIf(IsError(Sum(Abs([StatusIr]="Objective Meet"))/Sum(Abs(Not
[StatusIr]="No Objective Required")),1,Sum(Abs([StatusIr]="Objective
Meet"))/Sum(Abs(Not [StatusIr]="No Objective Required")))
With no Luck.
Thanks,
David Isaacks
[StatusIr]="No Objective Required"))
Sometimes in my query I get a #Error message. Of course I know why, it
cannot divide by zero. I would like to handle this error buy placing a
1 in the field is the an #error is returned.
I have tried
IIf(IsError(Sum(Abs([StatusIr]="Objective Meet"))/Sum(Abs(Not
[StatusIr]="No Objective Required")),1,Sum(Abs([StatusIr]="Objective
Meet"))/Sum(Abs(Not [StatusIr]="No Objective Required")))
With no Luck.
Thanks,
David Isaacks