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

       

      writing

       

      =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

       

      Morten