7 Replies Latest reply: Feb 20, 2014 1:07 PM by Alec Smith RSS

    Straight Table of No Sales for Given Year

    Alec Smith

      Hello,

       

      I built a straight table that only shows customers who have NOT purchased any products based on the selected list box year.  I added the following expression to exclude the current year selected.

       

      =Only({1-$}Year)


      I am getting the expected list of customers who have not purchased any products for the selected year.  However, the issue I am having is that I want to add an expression that will show the average potential sales (i.e average lost sales) for the selected year, but I cannot get the sum calculation to work. I tried the following expression to no success.  I'm not getting any numbers at all.

       

      =Sum((=Only({1-$}Year)> "Sales Amount") / (Max(=Only({1-$}Year) - Min(=Only({1-$}Year))

       

      Thank you in advance for any assistance.