Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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, '@'))
I continue with the same problem appears in the first row
You don't want to count it?
the first row that comes empty I do not want to tell
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))
just what I needed, thank you very much.
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)
You can mark Correct answer of sunny's latest reply. That may useful to others when they land-up to the same thread.