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

Wed, 02 Dec 2015 09:37:04 GMT

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?

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

tamilarasu — Thu, 03 Dec 2015 02:09:21 GMT

Hi Mavrinder,

Simply, put this in text box.

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

Even if it is zero, the sum will be same.