count and isnull

[davinfrost]

hi guys,
there is null value in So Number Edit
and i have to count So Number Edit

if i use this : 

='Total So Edit'&' = '&count(distinct [So Number Edit])
& ' Total Invoice = '&Count(DISTINCT([Total SO No]))

it will get null value,

i want it without null value ..

what should i do??

[saar_lorena]

Hi,

Try this:

In your script, first you need to check when is null or not.

So:

LOAD *, If(IsNull([So Number Edit]), 'T', 'F') as SoNumberEditIsItNull;

='Total So Edit'&' = '& If([SoNumberEditIsItNull]='T', count(distinct [SoNumberEditIsItNull])

[davinfrost]

hi , i want to count all status edit, but i dont want to count null data '-'

i want use this on textbox, i used this on chart, but it isnt work on textbox? 

=If(len(trim([So Number Edit]))='0','0',count(distinct[So Number Edit]))

[tresesco]

Try using set analysis like:

=count( {<[So Number Edit]={"=len(trim([So Number Edit]))>0 "  >} distinct [So Number Edit])

[davinfrost]

error in set modifier ad hoc element list.

[tresesco · Accepted solution]

Yeah, needs a correction. Try:

=count( {<[So Number Edit]={"=len(trim([So Number Edit]))>0 "} >} distinct [So Number Edit])