Want Information if cell is blank

[CIBS]

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

 

[DJWheezyWeez]

Instead of "" to identify null data, use isnull(). So your formula would read:
if isnull({DESCRIPTION}) THEN "UNKNOWN" ELSE {DESCRIPTION}

That may help. If not, assuming the fields for your REF and Description are different, try changing the link arrows. I'm not familiar with CR9 but if it's close enough to CR XI, use a left outer join then make sure the arrow is pointing to the table with the REF field.

Hope this helps.

-DJWW

 

[CIBS]

Cheers,
Works a treat