cancel
Showing results for 
Search instead for 
Did you mean: 

Combine fields in a formula where some fields are null

Former Member
0 Kudos
394

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

View Entire Topic
Former Member

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
0 Kudos

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