Hi I am trying to diplay Null values as data missing in a formula I can pick up the other values okay but when it comes to a null value the formula doesn't populate the field . Does any body know when assigning variables to fields does the IsNull construct work .Below is a description of what I am trying to do.
Local StringVar CourseType;
Local StringVar FundSource;
CourseType := {stcfesdt.course_type};
Fundsource := {stcfesdt.fund_source};
if IsNull({stcfesdt.fund_source})
then "D M"
else if CourseType = "99" and FundSource = "02"
then FundSource
else if CourseType = "06" and FundSource = "11"
then FundSource
else if CourseType = "20" and FundSource = "02"
then FundSource
else if CourseType = "18" and FundSource = "02"
then FundSource
else if CourseType = "10" and FundSource = "11"
then FundSource
else "Err"
IP Logged
