not is null

[gr_eldred]

I need to apply a count of a concatenated field but one of them contains a null try this but it has not been successful, can you help me ?.

count(Distinct Pto_vta_ID&%Folio_Fac)

Greetings.

[sunny_talwar]

Not sure what the issue you are running into because of null, but may be try this

Count(DISTINCT If(Len(Trim(Pto_vta_ID)) > 0, Pto_vta_ID, '@') & If(Len(Trim(%Folio_Fac)) > 0, %Folio_Fac, '@'))

[gr_eldred]

I continue with the same problem appears in the first row

[sunny_talwar]

You don't want to count it?

[gr_eldred]

the first row that comes empty I do not want to tell

[sunny_talwar]

You don't want to count that? May be this

Count(DISTINCT If(Len(Trim(Pto_vta_ID)) > 0 and Len(Trim(%Folio_Fac)) > 0, Pto_vta_ID&%Folio_Fac))

[gr_eldred]

just what I needed, thank you very much.

[Anil_Babu_Samineni]

You can try this way too? Create field in script.

If(Len(Trim(Pto_vta_ID)) > 0 and Len(Trim(%Folio_Fac)) > 0, 1,0) as Flag

And set Analysis should be like below

Count({<Flag = {1}>} Pto_vta_ID&%Folio_Fac)

[Anil_Babu_Samineni]

You can mark Correct answer of sunny's latest reply. That may useful to others when they land-up to the same thread.