11 Replies Latest reply: Jul 7, 2018 12:43 AM by Sohini Bhattacharyya RSS

    Set Analysis with Multiple Conditions

    Andrew Bullen

      Hi

       

      I am trying to get the below to return a %. I get the correct outcome although it is displayed as a decimal and not a %. Any ideas?

      =num(count({<CourseName={'*Performance and Development Plan (PAD)'},status={'Enrolled'}>}[IDM Nbr])+
      Count({<CourseName={'*Performance and Development Plan (PAD)'},TrainingStatus={'Not Current'}>}[IDM Nbr]))/
        num(count({<CourseName={'*Performance and Development Plan (PAD)'}>}[IDM Nbr]),'%')

       

      Cheers, Andrew