Find if List member exists in List formatted Line Item
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
Thanks a lot !
Best Answers
-
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.
3.Goto your product dimension —>Import —> Select Sys Product Module(Your moule name).
@andrewtye Thank you for your response 😊.
Hope this helps :).Thanks,
Venkatesh2
Answers
-
Hello Andrew, Venkatesh,
This works perfectly thank you very much both !
0