Skip to Content
avatar image
Former Member

Add a parameter to a field in a formula

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 26 at 06:56 AM

    Hi Terry,

    Create a formula with this code:

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • 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