AnsweredAssumed Answered

How to Set a Variable   List ( Field::1 if Field::2 =1)

Question asked by shae1725 on Dec 26, 2013
Latest reply on Dec 27, 2013 by philmodjunk

Title

How to Set a Variable   List ( Field::1 if Field::2 =1)

Post

     I have searched the forum for a calculated List view and I thought I found the answer but cant get it to work!

     I want a list of    pkColorID    IF    ColorID_Count greater or eq 1    (or notEmpty if that would be a better way to do it?)

      

     Set Variable[$$ColorGroups;Value:List (If (MP_ColorGroupID_Portal::ColorID_Count  ≥ 1; MP_ColorGroupID_Portal::pkColorID))]

Outcomes