This is a migrated thread and some comments may be shown as answers.

IsNull expression

1 Answer 464 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Dhyan
Top achievements
Rank 1
Dhyan asked on 07 Jun 2013, 03:45 AM

Whats wrong with this expression, logically i can print any default variable if a field comes as Null. 
= IsNull(Fields.ROE_wo_Reserves, Fields.Flat_Line_Rent) 

I am getting blank value as output everytime. 

1 Answer, 1 is accepted

Sort by
0
Squall
Top achievements
Rank 1
answered on 10 Jun 2013, 01:06 PM
Are the fields really null or they are blank? You can try to add a check for empty string:

= IIF(Fields.ROE_wo_Reserves is Null OR Fields.ROE_wo_Reserves = "", Fields.Flat_Line_Rent, Fields.ROE_wo_Reserves
Tags
General Discussions
Asked by
Dhyan
Top achievements
Rank 1
Answers by
Squall
Top achievements
Rank 1
Share this question
or