Function to determine if a list item belongs to a subset of the list

PrevContributor
PrevContributor
in Modeling

I'm trying to build an exception module to check that all items in a particular list with a particular property residing in another module belongs to a subset in the list. Is there any function like ISSUBSETOF(x) to determine if a particular item in a list belongs to a subset of the list? To illustrate, in a List called Products, there are many properties and among which, there are two Boolean properties: Managed Product and Sector Specific Product. The Product List also contains a subset called Strategic Sales Products that groups all the products with both properties being TRUE. The property is being updated once 6 months and I want to build a module to identify if there are items within the list with both property being true and is not defined in the subset.

Tagged:

Best Answer

  • PrevContributor
    PrevContributor
    Answer ✓
    Hi,

    Define List: Products

    Properties:
    • Managed Product    (Boolean)
    • Sector Specific Product   (Boolean)
    Subset:
    • Strategic Sales Products
    Define Module: SSP Transfer

    Applies to: Products

    Define Line Item: Old SSP
    Date Type: Boolean
    Formula: NOT ISBLANK(FINDITEM(Strategic Sales Products, NAME(ITEM(Products))))

    Define Line Item: New SSP
    Date Type: Boolean
    Formula: Products.Managed Product AND Products.Sector Specific Product

    Define Line Item: Transfer
    Date Type: Number
    Formula: IF Old SSP THEN IF New SSP THEN 0 ELSE -1 ELSE IF New SSP THEN 1 ELSE 0


    Old SPP is what you're looking for. Alternatively, each update cycle you can import into the Products List from the Transfer Module. You use New SPP as your source and SSP Subset as your Target.

    Hope this helps.

    Jack

Categories