Hi people

I have a small problem concerning calculation fields.

I have this calc field, Unit Price that calculates by how many the customer is ordering from us. (case(Quantity > 50 and Quantity < 50; 3.00; 4.00) etc. )

The problem occurs when someone wants to put in their own Unit Price regardless of what the calculation result of the Unit Price should be.

Anyone know how I might get around such problem?

Any nice tips on doing such a thing?

Thanxs

Steve Griff

One quick question to make sure I get this right. This involves having another field visible for entry yeah?

Is this the case of "one field above the other" trick? I can see how the Case works for this...

I guess this would work?

Steve

Create another field for overriding the calculation.

Then,

if (isempty(FieldForOverride) do the calculation, otherwise use FieldForOverride

Been there, done that...

Make another field, Override, and then change your Case() statement so that the first test is:

Case(Override, Override, ...now put your old tests...)

signal, you're too quick for me!