Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try like this
=COUNT({<ENTITY={'*'}>} [INT TRD ID])
Hope this helps you.
Regards,
Jagan.
Or alternatively, depending on what you need to display, the intersection of your current selection and your set analysis:
=COUNT({<ENTITY*={'*'}>} [INT TRD ID])
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.
hi what * will do? Is it possible to convert my same expression in Set analysis.
thnanks
Hi,
Is it working? * will exclude all the null values.
=COUNT({<ENTITY={'*'}>} [INT TRD ID])
Regards,
Jagan.
COUNT({<ENTITY={'*'},ENTITY>} IF(LEN(TRIM(ENTITY))>1,[INT TRD ID]))
Hi jagan
But I want to exclude null value s
Thnx