4 Replies Latest reply: Jan 29, 2016 12:32 PM by Oleg Troyansky RSS

    Expression based on another expression value

      Hi all,

       

      I have the following 2 expressions:

      Total Visits
      =SUM( <{Store=, Location='Location A'}> Visits)

      Total Sales
      =SUM( <{Store=, Location='Location A'}> Sales)

       

      Is it possible to create an expression based on these 2 for: Total Sales where total number of visits >= 3 ?

      I need to incorporate the total of one expression in another expression, but I do not know how to achieve this...

       

      Thanks

      Jon!