alas

Most efficient way to write this calculation

Discussion created by alas on Nov 12, 2012
Latest reply on Nov 13, 2012 by flusheddata

I have four fields (FIELD1, FIELD2, FIELD3, FIELD4). The fields may be empty or have content.

 

I want to have a formula that does FIELD1 & "¶" & FIELD2 & "¶" & FIELD3 & "¶" & FIELD4, so I would end up with:

 

FIELD1

FIELD2

FIELD3

FIELD4

as the result.

 

However, if one of the fields is empty, I don't want it to have the extra carriage return.

 

For example, if FIELD2 is blank, I do not want:

FIELD1

 

FIELD3

FIELD4

 

Instead, I want:

FIELD1

FIELD3

FIELD4

 

I am trying to create this calculation as effiiently as possible. Right now I have it working extremely inneficiently, as it has multiple nested IF's with IsEmpty. I've done this before with only two fields and it is pretty straight forward. But the number of combinations with 4 fields is a real bear.

 

Any suggestions of better approaches?

Outcomes