Hi
I Am Using CR 9
I have a field that may or mynot contain data.
Fields used
Description
Reference
@Formula
what I want is the @formula table above to display "Unknown" if there is a reference No. but the Description table is blank, but if there is information in the Description table then it displays that.
My problem is I am not sure how to Handle the blank description. Currently I have the following. (YES I KNOW IT DOESN'T WORK BUT WILL DEMONSTRATE WHAT IAM AFTER)
if{DESCRIPTION} = "" THEN "UNKNOWN" ELSE {DESCRIPTION}
EXAMPLE OF DATA
REF - Description - @Formula
1596 - Toaster - Toaster
1623 - - UNKNOWN
19563 - Kettle - Kettle
Please help, I know it's a simple answer and it's at the tip of my tongue but I' stuck at the moment
Kind Regards
Stephen
I Am Using CR 9
I have a field that may or mynot contain data.
Fields used
Description
Reference
@Formula
what I want is the @formula table above to display "Unknown" if there is a reference No. but the Description table is blank, but if there is information in the Description table then it displays that.
My problem is I am not sure how to Handle the blank description. Currently I have the following. (YES I KNOW IT DOESN'T WORK BUT WILL DEMONSTRATE WHAT IAM AFTER)
if{DESCRIPTION} = "" THEN "UNKNOWN" ELSE {DESCRIPTION}
EXAMPLE OF DATA
REF - Description - @Formula
1596 - Toaster - Toaster
1623 - - UNKNOWN
19563 - Kettle - Kettle
Please help, I know it's a simple answer and it's at the tip of my tongue but I' stuck at the moment
Kind Regards
Stephen