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