1 2 Previous Next 19 Replies Latest reply on Nov 13, 2012 8:57 PM by flusheddata

    Most efficient way to write this calculation

    alas

      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?

        1 2 Previous Next