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

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



      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?