if then formula just not right 1

[brecat77]

IF ISNULL ({INVENTRY.IssueUnitOfMeasure}) THEN {TRANS.quantity}

ELSE {TRANS.quantity}*.3048

my problem is this, i only need {TRANS.quantity} to multiply by .3048 if the ({INVENTRY.IssueUnitOfMeasure}) is = MT otherwise i need it to just be {TRANS.quantity}.

Any help here would be greatly appreciated.

 

[dunlop1975]

IF ISNULL ({INVENTRY.IssueUnitOfMeasure}) THEN {TRANS.quantity}
ELSE IF {INVENTRY.IssueUnitOfMeasure}) = "MT" THEN {TRANS.quantity}*.3048
ELSE {TRANS.quantity}

 

[ianoctdec]

Hello,

if not isnull({INVENTRY.IssueUnitOfMeasure}) then
if {INVENTRY.IssueUnitOfMeasure} = 'MT' then
{TRANS.quantity}*.3048
else
{TRANS.quantity}
else
{TRANS.quantity}

Dana

 

[brecat77]

that works great except that if i put anything into the field of ({INVENTRY.IssueUnitOfMeasure}) it multiplies it by .3048. such as MT is in there for about 6 items, the rest are blank, this is fine, but if i put in anything into the field of ({INVENTRY.IssueUnitOfMeasure}) it multiplies it by .3048

 

[skaestner]

IF {INVENTRY.IssueUnitOfMeasure}) = "MT" THEN {TRANS.quantity}*.3048

else THEN {TRANS.quantity}

 

[ianoctdec]

OK, maybe {INVENTRY.IssueUnitOfMeasure} is not null, just empty; update as follows:

if not isnull({INVENTRY.IssueUnitOfMeasure}) and trim({INVENTRY.IssueUnitOfMeasure}) <> '' then
if {INVENTRY.IssueUnitOfMeasure} = 'MT' then
{TRANS.quantity}*.3048
else
{TRANS.quantity}
else
{TRANS.quantity}

Dana