2 Replies Latest reply on Sep 26, 2012 6:44 AM by MaureenRay

    Calculated Value Field and Paragraph Help

    MaureenRay

      Title

      Calculated Value Field and Paragraph Help

      Post

           I have a Calculated Value field that looks like this:

           List (CommentsELA::English) &"¶"  &
           List (CommentsMath::English) &"¶"  &
           List (CommentsBehavior::English) & "¶"  &
           List (CommentsWorkHabits::English) & "¶"  &
           List (CommentsGeneral::English) & "¶"  &
           AComments

           However, sometimes the List is empty, therefore I do not want a paragraph.  What would be the code for "If there is something in the list, insert a paragaraph, if not, then don't".

           Thank you for your help!

            

        • 1. Re: Calculated Value Field and Paragraph Help
          philmodjunk

               Does List (CommentsELA::English )

               Return a single value or a list of values?

               If a single value, use:

               List (CommentsELA::English ;
               CommentsMath::English ;
               CommentsBehavior::English ;
               CommentsWorkHabits::English ;
               CommentsGeneral::English ;
               AComments )

               If multiple values are returned by that use of list, use this expression:

               List (

               List (CommentsELA::English) ;
               List (CommentsMath::English) ;
               List (CommentsBehavior::English) ;
               List (CommentsWorkHabits::English) ;
               List (CommentsGeneral::English) ;
               AComments

               )

          • 2. Re: Calculated Value Field and Paragraph Help
            MaureenRay

                 Thank you, PhilModjunk, for the post.  It works perfect.