6 Replies Latest reply: May 8, 2013 11:02 AM by Anand Krishna RSS

    using variables in set analysis

      Hi there,

       

       

      I have  a variable (v_on_season) that calculates the number of thansactions that a customer performs in a selected period , eg Q1 2012. and another variable (v_off_season) that calculates the number of thansactions that a customer performs in another selected period , eg Q4 2012.

       

      I want to calculate the number of customers that performed at least one transaction in the first period and at least 100  in the other selected period.

       

      So if customer_id is the calculated field i want to calculate something like this:

       

      count ( {$< $(v_on_season) > 0 , $(v_off_season) >= 100>} customer_id)

       

      Any help would be very appreciated.

       

      Thank you in advance.