Tables: left outer join: field with no content in formula

[iemand]

I joined two tables with a left outer join. In some cases this results in blank fields because records do not exist.
This is logical. BUT: I want to use a specific field that sometimes is blank in a formula like this: if the field has a content, take the value of the content otherwise take value 1.
This does not work. Some ideas?

 

[goranm]

Hi !

If you try and test for the blank first I think you will get it right.

if isNull({YourField}) then
'1'
else
{YourField}

/Goran

 

[synapsevampire]

Just in case, add to that:

//If a number:
if isNull({YourField}) or {YourField} = 0 then
1
else
{YourField}

//If a string
if isNull({YourField}) or {YourField} = "" then
1
else
val({YourField})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com