Find if List member exists in List formatted Line Item

QZ
QZ
edited May 2023 in Modeling

Hello,

I'm struggling with this problem: I have a module named "Example" using two dimensions: "Dummy" and "Test". It contains a line item called "Item" which is formatted as "Product", Product being a list.

I would like to create a subset of only the products that have been used in this module but cannot find a way to make it work. The way I would create the subset is with a SYS module that has Product as a dimension and a Boolean line item named "Included" that would be checked when Product is used in Example.

Can anyone help me find the formula to write in "Included" ?

See below the module in question: In that case my SYS module would check only Products A, B and D

image.png

Thanks a lot !

Best Answers

  • andrewtye
    andrewtye
    Answer ✓

    Hi @QZ

    If you put in a boolean line item into your module and have it being true if item is not blank

    Then in your SYS module for product have a line item which is Boolean[ANY: Example.Item] and then can have an import into the list subset

    Hope that helps

    Andrew

  • Venki9902
    Venki9902
    edited May 2023 Answer ✓

    Hi @QZ ,

    Please find the steps below for creating a subset using the Sys module.
    1. Add one more line item in your example module called "Boolean" and formula should be "isnotblank(Item)".

    2. In your sys module the formula you can use the below formula.

    image.png

    3.Goto your product dimension —>Import —> Select Sys Product Module(Your moule name).

    Action Detials.PNG

    @andrewtye Thank you for your response 😊.

    Hope this helps :).

    Thanks,
    Venkatesh

Answers

  • QZ
    QZ

    Hello Andrew, Venkatesh,

    This works perfectly thank you very much both !

Categories