7 Replies Latest reply: Aug 1, 2017 4:06 PM by mark pratt RSS

    Previous 6 months within Set Analysis

    mark pratt

      Here is two of my attempts, but I just get null or 0. I have made sure both fields are dates without time stamp, fixed in load.

       

      ((Count(distinct{<DDA_External_Tran_Code*={'5'},

      DDA_Tran_Date*={>=$(addmonths(today(),-6))}>}DDA_Description_Link)) +

      (Count(distinct{<SAV_External_Tran_Code*={'125'},

      SAV_Tran_Date*={>=$(addmonths(today(),-6))}>}SAV_Description_Link)))

       

       

      ((Count(distinct{<DDA_External_Tran_Code*={'5'},

      DDA_Tran_Date*={">=AddMonths(Today(),-6)"}>}DDA_Description_Link)) +

      (Count(distinct{<SAV_External_Tran_Code*={'125'},

      SAV_Tran_Date*={">=AddMonths(Today(),-6)"}>}SAV_Description_Link)))

       

       

      I just want transactions from previous 6 months. I feel confident I could achieve with If statement but would rather keep everything as set analysis if possible. I have probably 15-20 calculations with multiple set analysis that each will need to pull just the previous 6 months worth of data. Unfortunately filtering at the data load isn't going to be a viable option either, please help. Thanks everyone in advance!