6 Replies Latest reply: Oct 10, 2018 3:09 AM by David Štorek RSS

    Greater than or less than a Variable in set analysis

    Janani Reddy

      Hello,

       

      I am trying to do a condition to achieve results greater than and less than a particular period (In the format YYYY-MM)

       

      count({<Sales_Month_Year ={">=$(=vMinSalesPeriod)<=$(=vMaxSalesPeriod)"}>} ID)

      This does not work for me. My data looks this way:

       

      Sales_Month_Year

      2018-01

      2018-02

      .

      .

      and so on

       

      And the Variable are captured in the format same format. How ever this works for me

      count({<Sales_Month_Year = {"=$(vMinSalesPeriod)"}>}VIN)

      But the moment i put a greater sign in that statement it shows 0 records

      count({<Sales_Month_Year = {">=$(vMinSalesPeriod)"}>}VIN)



      Thanks in advance

      Janani