expression in set analysis ... urgent!!!!

[#1]

Hi all,

This is my current expression=COUNT(if(ENTITY<>NULL() AND LEN(TRIM(ENTITY))>=1,INT TRD ID)).... I need to acheive the same in set analysis.

Thanks in advance

[jagan]

Hi,

Try like this

=COUNT({<ENTITY={'*'}>} [INT TRD ID])

Hope this helps you.

Regards,

Jagan.

[simondachstr]

Or alternatively, depending on what you need to display, the intersection of your current selection and your set analysis:

=COUNT({<ENTITY*={'*'}>} [INT TRD ID])

[#4]

Hi Jagan Mohan,

I need to create one straight table or pivot table. I need to get Sum(Amount) where ActualID=AccountID. for each individual employee. The dimension is EmployeeID. But this EmployeeID and Amount are from one table, whereas ActualID is from another table.

Could you help me how to write the expression please as it is urgent for me please

Thanks.

[#5]

hi what * will do? Is it possible to convert my same expression in Set analysis.

thnanks

[jagan]

Hi,

Is it working?  * will exclude all the null values.

=COUNT({<ENTITY={'*'}>} [INT TRD ID])

Regards,

Jagan.

[#7]

COUNT({<ENTITY={'*'},ENTITY>} IF(LEN(TRIM(ENTITY))>1,[INT TRD ID]))

[#8]

Hi jagan

But I want to exclude null value s

Thnx