Exclude Nulls

[soniasweety]

Hi all,

I have a column  Status

in that values are like below

Status

success

"success with no issue "

Failed

Unsuccessfull

-

so here  my requirement is  :    Caluclate the  Failed %

logic :  if(Status='successful' or Status='success With No Issues' or close_code='successful_issues', 'Yes','No') as StatusFlag,

Front end :

count({<StatusFlag={'No'}>}Number)

/count(Number)  

its working but  in data I have null values  if I take  flag value "No"   except success null also taking into consideration so  I want to exclude that  how to do?

[sudhirpkuwar]

You just need the Failed % right....?

[singbittoo]

tamil's expression will work in front end, for script level

you can write

** the below one is also tamil's code only just the '' i replaced with 'null'

If(Isnull(Status),'null', If(Match(Status,'successful','success With No Issues','successful_issues') , 'Yes','No')) as StatusFlag

and in your older expression will work fine

[soniasweety]

yes sudhir