Hello,

I have the following field in my formula:

{InvWarehouse.QtyOnHand}

I would like to set a parameter against that field to only show "QtyOnHand" where

{InvWarehouse.Warehouse} = 10INV

How would I correctly format this to achieve my objective?

Thanks.

Hi Terry,

Create a formula with this code:

IF {InvWarehouse.Warehouse} = '10INV' then {InvWarehouse.QtyOnHand}

-Abhilash

You already have an active moderator alert for this content.

Modify the formula to:

IF {InvWarehouse.Warehouse} IN ['10INV', '10WAY'] then {InvWarehouse.QtyOnHand}

Insert a summary on this formula field from the "Insert Summary" option.

## Add comment