6 Replies Latest reply: Jan 19, 2015 10:52 AM by Piet Hein van der Stigchel RSS

    Only show values in list box with sales volume

      Hello,

       

      I have a list box showing Product Descriptions. I would like to only show values in this list box that have an associated volume. I have tried the following in the <Expression> option of the field drop down, but it selects the 'Actual Volume' field as well when I use the 'Product Description' list box as a filter:

       

      =if([Actual Volume]>'0',[Product Description])

       

      Please can you advise?

       

      Thank you,

      Mel