Combine fields in a formula where some fields are null

[Former Member]

Hello,

I try to combine the fields Keteltype1, KetelType2 and KetelType3. The formula is correct, but I do not get the result I want.

Sometimes there is no data in the fields Keteltype1, Keteltype2 and Keteltype3. So these lines are blanc. The field Keteldeel is always filled with data.

This is the formula I use:

{@Keteldeel} + ' ' + {@KetelType1} + {@KetelType2} + {@KetelType3}

Can anyone let me know what the formula should be, so that I do not get blanc lines.

Thanks,

Tim

[Former Member · Accepted solution]

Hi Tim,

Do the following to get desired results with your formula :

{@Keteldeel} + ' ' + {@KetelType1} + {@KetelType2} + {@KetelType3}

Edit the above formula and on top you will see 'Exception for Null' option with drop down and select 'Default values for Null' and save. This will give you the desired results.

Thanks,

Sastry

[Former Member · Accepted solution]

Hello Sastry,

If many things where that easy....

You solved my problem the easiest way.

Ian's should work too, so thanks for your solution as well.

Thanks,

Tim

[Former Member]

The easiest solution is to use a text box and just place the 4 fields as you want with a space after Keteldeel . Do not use formula. Then right click text box , select format and check Suppress embedded field blank lines.

Or you can do the following modify the 3 formula you have created to be like this

{@KetelType1}

If isnull() then "" else &" "

repeat for types 2 & 3 then combine as you have done

{@Keteldeel} + ' ' + {@KetelType1} + {@KetelType2} + {@KetelType3}

This will put spaces between each one, if you do not want spaces remove &" "

Ian