cancel
Showing results for 
Search instead for 
Did you mean: 

Add a parameter to a field in a formula

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Terry,

Create a formula with this code:

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

-Abhilash

Former Member
0 Kudos

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.

abhilash_kumar
Active Contributor
0 Kudos

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

Answers (0)