5 Replies Latest reply: Oct 30, 2014 10:51 AM by Anand Chouhan RSS

    Simple set analysis

      Hi all


      im trying to do a simple set analysis wich restricts the expression the past 6 months. spending a lot of googletime all i came up with is:


      =count({<datLatest= {">= addmonths(Today(),-6,0)"} >} FVID)


      however all i get i zero. could somone show me the correct syntax




      =count(if(datLatestdate_historic>addmonths(Today(),-6,0), FVID))


      gets what i want, but im trying to learn the set analysis way of things



      ps. using 11 SR 2

      best regards