3 Replies Latest reply: Sep 17, 2014 10:05 AM by Manish Kachhia RSS

    Making a list box ignore a specific selection

      Hi all,

       

      I'm sure there's a very simple solution to this, but I can't find one anywhere on here.

       

      Basically, I have a Field (Period) that always has to have a selected value (this must remain the case).

       

      This has not been an issue in other parts of my document as I've been able to use sum({<Period>}.......) to make any sums I've used ignore this selection.

       

      However, I now need to display a Field (Cost Centre Manager Comments) in a list box, and have that ignore the selected value from Period, and I can't use sum as it isn't actually summing anything, it's just displaying the Field data.

       

      Basically I need a list box expression so that this field is displayed , ignoring the specific Period selection (whilst not ignoring any other selections)

       

      Thanks in advance