2 Replies Latest reply on Apr 25, 2016 10:39 AM by ryan.shukis

    Filtering by Calculation

    ryan.shukis

      I am creating a dashboard where our sales reps can view their customers who have the highest average purchase.

       

      However, I would like for them to filter out those customers that have only purchased once if they want to.

       

      So I was thinking of having a parameter/formula such as:

       

      CASE [Show Ordered Once]  --this is a boolean

      WHEN 'Yes' THEN [# Times Ordered]  --purpose is to show all values

      WHEN 'No' THEN [# Times Ordered] > SUM(1)  --purpose is to show only where they ordered more than once.

      ELSE ''

      END

       

      I have a feeling that what I'm doing wrong would be blatantly obvious to some of you on here so any help is much appreciated!

       

      I have also tried this as well:

       

      IF INT([# Times Ordered]) > INT(1) then [Parent Organization] ELSE '' END , but then the "cannot mix aggregate  and non aggregate formulas" error comes up.

       

      Thank you