Use the if statement within the calculation of the calculated field.
if(divisor=0,0,do calculation)
This should do the trick.
Rick Lane
Intelligent Systems Integration, Inc.
661B Weber Drive
Wadsworth, OH 44281
330-335-5291
Fax: 330-335-7275
"Helping business make intelligent use of technology"
-----Original Message-----
I have a question about Report Builder. (actually may be an easy question
for some? just not me.)
I have created a report including job costs. My problem is that in one of
the calculations, there is division. If we have a job that does not have
cost or a completed qty, there is division that includes a 0, therefore I
get the "?????????" error in calculation. When I do a total on a field that
has "???????" I receive the same answer "?????????????". I know in the
aggregate field I can click on Ignore Unknown or 0, but this does not work.
Is there a way to have the aggregate ignore an error?
Thank you in advance for your help,
Joy
if(divisor=0,0,do calculation)
This should do the trick.
Rick Lane
Intelligent Systems Integration, Inc.
661B Weber Drive
Wadsworth, OH 44281
330-335-5291
Fax: 330-335-7275
"Helping business make intelligent use of technology"
-----Original Message-----
I have a question about Report Builder. (actually may be an easy question
for some? just not me.)
I have created a report including job costs. My problem is that in one of
the calculations, there is division. If we have a job that does not have
cost or a completed qty, there is division that includes a 0, therefore I
get the "?????????" error in calculation. When I do a total on a field that
has "???????" I receive the same answer "?????????????". I know in the
aggregate field I can click on Ignore Unknown or 0, but this does not work.
Is there a way to have the aggregate ignore an error?
Thank you in advance for your help,
Joy