Min/Max Tolerance 1

[dtol22]

Trying to come up with a formula to print a specific message if a value is out of tolerance based on the value in another field. I'd like to be able to do a specific value above and below.

example:

if {table.shippingweight} is 200 lbs > {table.plannedweight} else "DO NOT PRINT"

Here is the current formula that I'm using and it works perfectly but need to add the above criteria to the mix:

if ({INVENTSERIAL.KRV_SHIPPINGWEIGHT} = 0 or
{INVENTSERIAL.WATERCAPACITY} = 0 or
{KRV_UNITSPECIFICATION.WASTEWATER} = 0 or
{INVENTSERIAL.LPGASCAPACITY} = 0 or
{INVENTSERIAL.ACTUALOFFLINE} = Date (1900,1,1) or
{INVENTTABLE.LEGALMODEL} = "") then "DO NOT PRINT"

Any help would be greatly appreciated!

 

[fisheromacse]

i believe you could add the below to your existing criteria:

or {table.shippingweight} = ({table.plannedweight} + 200)






ie:
if ({INVENTSERIAL.KRV_SHIPPINGWEIGHT} = 0 or
{INVENTSERIAL.WATERCAPACITY} = 0 or
{KRV_UNITSPECIFICATION.WASTEWATER} = 0 or
{INVENTSERIAL.LPGASCAPACITY} = 0 or
{INVENTSERIAL.ACTUALOFFLINE} = Date (1900,1,1) or
{table.shippingweight} = ({table.plannedweight} + 200) or
{INVENTTABLE.LEGALMODEL} = "") then "DO NOT PRINT

 

[dtol22]

Believe that gets me over the hump. Appreciate the response.

 

[fisheromacse]

at second glance, i think

{table.shippingweight} = ({table.plannedweight} + 200)

should be

{table.shippingweight} > ({table.plannedweight} + 200)

 

[dtol22]

You are correct, you do need the < or >. Figured that out after the first couple of test runs.

Worked like a charm, by the way. Thanks again for your help.