1 Reply Latest reply: Dec 2, 2015 9:11 PM by Tamil Nagaraj RSS

    Help with an expression - might be a simple solution I think but need guidance

      Hi,

       

      I have created a table that has 'Name' as the dimension and the following expression:

       

      if(Count(${<Skill={'Pro','Amateur'}, Role={'Senior'}, Active={'Y'}, NoOfDaysPassed={">30"}>} ID)>=1,1,0)

       

      The above criteria returns a 1 for names in the dimension.

       

      I wanted to know how to get the sum/total for this and be able to put it into a Text Object.

       

      Any ideas on what the best way to do this is?