8 Replies Latest reply: Sep 22, 2015 11:59 AM by Nick King RSS

    Greater Than in Set Analysis

    Nick King



      I'm trying to sum a field where it's week paid date is greater than the 24/08/2015 using Set Analysis where the date of the 24/08/2015 is calculated by a variable. When I view the variable result in a text box is displays as 24/08/2015. When I use that variable in Set Analysis I get no answer to the calculation. If I just type the date in manually it works.


      This is how it looks with the date manually typed



      This is my latest attempt at getting that to work with the variable

      =Sum({1<WeekPaid={">=$(vFour_Weeks_Ago)"}>} treatment_count)


      =$(vFour_Weeks_Ago) returns 24/08/2015


      Where am I going wrong?