Avoiding Null in Text Object

[Anonymous]

Hi all,

How we can avoid Null() values in set analysis expressions.

We have a requirement, where we want distinct count of dim1, where dim2 should not be Null.

We have tried,

-     dim2={*}-{''}

-     dim2 = {'*?'}

-     Not IsNull(dim2)

all these expressions are not working in below case

count(distinct {<Expressions>}dim1)

Please assist.

Regards,

MK

[sunny_talwar]

you can try this:

{<dim2 = {'*?'}>}

Update: Just realized that you mentioned that the above is not working. You can try this

{<dim2 = {"=Len(Trim(dim2)) <> 0"}>}

[Anonymous]

already tried, not working.

[#4]

Hi,

Please try this code:

=Count(distinct{<dim1={'<>'''}>}dim1)

Regards,

Jemimah

[sunny_talwar]

try this:

{<dim2 = {"=Len(Trim(dim2)) <> 0"}>}

[Anonymous]

not working....:(

[Anonymous]

nope

[sunny_talwar]

Would you be able to share a sample which shows the issue you are having?

[Anonymous]

If i try it on altogether new app, with dummy data, then its working as expected, but with complex data model (which i cant share) its giving problem

[antoniotiman]

How are You loading Table with dim1 and dim2 ? From Load or DB ?