help on Expression

[sayadutt]

Hi Team,

I have one expression where I am calculating count of all BLANK values like below.

=(count({<myfield={''}>}myfield)/count(myfield) )

Now I want to use another expression which will give me count of all NON BLANK values.

Is short, how to add NOT operator in the above expression.

Thanks

[avinashelite · Accepted solution]

try like this

=(count({<myfield - ={''}>}myfield)/count(myfield) )

[maxgro]

try

=( count({<myfield={"=Len(Trim(myfield)) = 0"}>}myfield) / count(myfield) )

[avinashelite]

or

if(len(trim(myfield)>0,count(myfield) )

[tamilarasu]

Try like below,

=count({<myfield={'*'}>}myfield)/count(myfield)

Or

=count({<myfield={"=Len(Trim(myfield)) <> 0"}>}myfield) / count(myfield)

[MayilVahanan]

Hi

Try like this

=( count({<myfield={"=Len(Trim(myfield)) = 0"}>}myfield)

[jagan]

Hi,

Try this

=(count({<myfield={''}>}myfield)/count(myfield) )

The best approach is to handle this in script

LOAD

*,

If(Len(Trim(FieldName)) = 0 , 1, 0) AS Flag

FROM DataSource;

Now use below expression

For Blank values:

=(count({<Flag={1}>}myfield)/count(myfield) )

For Non Blank values:

=(count({<Flag={0}>}myfield)/count(myfield) )

Hope this helps you.

Regards,

Jagan.