Exceptions to the rule

L

Lori

I'm not sure if I put this up already, I haven't gotten an answer but here
goes.

I have a query where information is pulled from my scope change table,
including Company name, Amount of the scope change and some dates. I have
inserted fields that will calculate the markups on the amount of the change
to the percentage allowed by our owners for General Conditions, Insurance,
Bond and Fee. There are a couple of exceptions to these percentages.

In our first change there was no insurance or bond included but naturally my
fields are calculating numbers for these items. is there a way to create an
exception that will allow me to either manually delete these or edit these
from specific line items?
 
K

KARL DEWEY

If there will never be any with a zero value then use zero and an IIF
statement to not calculate the zero into the equation.
 
L

Lori

There is a zero value in the first change. Two of the normal markups were not
taken which results in an overall difference of 100K, the other problem is
that one of the markups should be .09 but in the first 4 letters it was
written at .1. These first few letters are the reason for this whole question.
 
Top