7 Replies Latest reply: May 24, 2012 11:21 AM by Deepak Vadithala RSS

    text box over table that disappears when 2+ months are selected

    chris goudy

      I"m trying to make a text object over a table that will disappear once two or more months are selected

       

      I have this in the text box on the General page of the properties

       

      =if(count(DISTINCT Month) > 2, 'Please select two Months minimum', if(count(DISTINCT Month) = 1, 'Please select at least one more Month',)) &

      chr(10) & chr(10) &

      'You may have to clear selections prior to using these charts.'

       

      and this on the Layout page show conditional

       

      count(DISTINCT Month) <=2