Skip to Content
0

Add a parameter to a field in a formula

Jan 26 at 01:44 AM

51

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Abhilash Kumar
Jan 26 at 06:56 AM
0

Hi Terry,

Create a formula with this code:

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

-Abhilash

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

0

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

0