Exceptions to the rule

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lori - 28 Aug 2006 20:02 GMT

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?

Signature

Lori A. Pong

Reply to this Message

KARL DEWEY - 28 Aug 2006 20:42 GMT

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.

> I'm not sure if I put this up already, I haven't gotten an answer but here
> goes.
[quoted text clipped - 9 lines]
> exception that will allow me to either manually delete these or edit these
> from specific line items?

Reply to this Message

Lori - 28 Aug 2006 20:51 GMT

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.

Signature

Lori A. Pong

> 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.
[quoted text clipped - 12 lines]
> > exception that will allow me to either manually delete these or edit these
> > from specific line items?

Reply to this Message