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
Thanks Abhilash,
If I have 13 different warehouses but I only want the sum of {InvWarehouse.QtyOnHand} for two of the 13 warehouses, how would I correctly format that?
The 2 warehouses are 10INV and 10WAY.
Sorry, I should have included this in my first post.
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.
-Abhilash