To handle null value

[yogitamehta10]

Hi All,

I have a variable.

if [Dimension]>$(variablesomevalue),'Yes','No)

my issue is Everything is coming no  all the null values are no  here . I just want real values to compare with these  variable and assign yes and no.

how I should ignore null values  here.

[yogitamehta10]

I can usein expression   to check null values because I have another step before that.

ID  Fieldname (numericvalue) fieldname2    

1      4                                          yes

2      7                                          No

3      8                                           yes

4                                                    NO

5      9       

so I should have two variables one  variable is for field 1 and another is field 2  then there is third variable  which says if both values are yes  in both the fields  then is should be yes , otherwise No. so need to figure out null values at variable level.        then need to compare values of both the fields and then in expression I need to calculate %.             

[yogitamehta10]

any Help ?

[sunny_talwar]

I wish to, but I am really not sure I understand what you have and what you are looking to do.

[yogitamehta10]

HI sunny,

Thanks for your reply

my first step is to convert  numbers in to Yes and No

so I have suppose two fields

ID     value

1     4

2  

3   8

4    9

5    10

6   21

so instead of number I want yes no  cant use in main expression as I need to compare  this yes and no with other fields then  will calculate %

no now I have  to write a if condition.

if (value>4, 'YES', 'No')

but the problem is when I check the count of yes  it says  4 that is right but when I say count of no it says 2. but actually it should be 1.

I hope i'm clear.

[sunny_talwar]

I guess try this

If(value > 4, 'YES',

If(value <= 4 and Len(Trim(value)) > 0, 'No'))

[yogitamehta10]

so now I got Yes and No in field likewise in  I have created another expression for different field and got the yes no value , now I need to compare values of there two fields and say  if both the value are yes then yes otherwise No.

[sunny_talwar]

May be like this

If(Expression1 = 'YES' and Expression2 = 'YES', 'YES', 'NO')