8 Replies Latest reply: Apr 26, 2018 3:38 PM by Dan Green RSS

    Return two results from IF

    Dan Green

      I have an IF statement as a variable in set analysis. I want it to show both Assigned and Completed items if nothing else in this field is selected but I am unable to figure this out.


      This is what I tried:


      vHideUnassigned = If(GetSelectedCount(AssignedCompleted) = 0, 'Assigned' and 'Completed', GetFieldSelections(AssignedCompleted))


      Measure in Chart: