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

    Greater Than in Set Analysis

    Nick King

      Hi,

       

      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

      =Sum({1<WeekPaid={">=24/08/2015"}>}treatment_count)

       

      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?

       

      Thanks

      Nick