K
K
I have a query that has a value of zero (by calculation) and when I run my
query I get the error: divison by zero. I can't figure out how to set the
query to accept a NULL value.
Here is my formula:
Specificity %: (([Sum Of SumOfTrue (-)]/([Sum Of SumOfTrue (-)]+[Sum Of
SumOfFalse (+)]))*100)
Several of these SUM calculations are = to zero.
Thanks
query I get the error: divison by zero. I can't figure out how to set the
query to accept a NULL value.
Here is my formula:
Specificity %: (([Sum Of SumOfTrue (-)]/([Sum Of SumOfTrue (-)]+[Sum Of
SumOfFalse (+)]))*100)
Several of these SUM calculations are = to zero.
Thanks