Highlighted
Occasional Contributor

Using subsets as conditions in the formula of list properties

Hi ,

 

  I need help on the subject . I would like to give a conditional formula for one of my list properties based on the list subset involved. Please let me know if this possible , if yes, how ? Also if not, please suggest alternatives. 

 

Thanks in advance!

-Aishwarya

6 REPLIES
Contributor

Re: Using subsets as conditions in the formula of list properties

HI Aishwariya,

 

I have 2 suggesstions for this!! However you can't refer a subset directly in a formula but you can try the below.

 

Suggestion 1: Create one more property(boolean formatted) in that list and while updating that subset through import update this property as well so that you can refer this property in any formula.

 

Suggestion 2: 

Step 1: Create a module with the subset and create a line item(boolean formatted) in it. Put "True" in the formula.

Step 2: Create a property(Boolean formatted) in that list and just do refer the above line item so that this property will be ture only for those subset. Hence you can refer this property for writing conditional formula. Refer below screen shots.

Subset Module

Using subsets as conditions in the formula of list properties.PNG

List:

Using subsets as conditions in the formula of list properties 1.PNG

Hope these solutions would confirm your request! :)

 

Let me know if you have any concerns.

 

Thanks

Kavin

Regular Contributor

Re: Using subsets as conditions in the formula of list properties

I would agree with everything Kavin said above except the last piece.  There is no need to have an additional property in the list when you already have the same data (boolean) in the module defined by the subset.  Your downstream formulas should just check if the member, in this case Products, are true in the module.  This way, you are keeping your lists clean (no properties), as well as you are only defining the formula once (in the module) so the system doesn't have to replicate the formula multiple times.

 

Thanks,

Rob

Contributor

Re: Using subsets as conditions in the formula of list properties

@rob_marshall Agree :)

Occasional Contributor

Re: Using subsets as conditions in the formula of list properties

Hi @kavinkumar  and  @rob_marshall 

 

     Thanks a lot for your solutions. Meanwhile, our team arrived at a solution using NOT ISBLANK function. The screenshot of the same is attached herewith. Supplier 1 and Supplier 2 are subsets of the list called 'Supplier'. Request your inputs on the same. 

 

Thanks and regards,

Aishwarya

 

 

 

 

 

 

 

 

Contributor

Re: Using subsets as conditions in the formula of list properties

@Aishwarya yes this should work :). But one small request, instead of NOT ISBLANK() tell the system ISNOTBLANK() so that it will be one request and performance wise it will be good. In NOT ISBLANK() you are giving 2 conditions (first system will check for ISblank and then Not) but you can bring it in this way. Otherwise your logic is good.

 

Thanks, 

Kaivn.

Occasional Contributor

Re: Using subsets as conditions in the formula of list properties

@kavinkumar Kavin , Thank you for enhancing our idea from model performance point of view! 

 

Thanks,

Aishwarya