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

[#1]

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?

[tamilarasu]

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.