13 Replies Latest reply: Feb 16, 2013 9:48 AM by Gysbert Wassenaar RSS

    Rolling 12 days

    Dan-Ketil Jakobsen

      Hi

       

      I need to create formula that counts a measure the last 12 days.

      It should allways be tha last 12 days even if one select other periods from timetable.

       

      I tired this one:

       

      =

      COUNT(DISTINCT if([Date record was created.] >= date(num(today()) -12) and TO_LOCATION LIKE 'INN_MONO_0*' and ((not([UOM for FROM_QTY.] like 'RC')) and FROM_LOCATION LIKE '1*'),TO_LIC

      ,0))

       

      My original formula

       

      =

      COUNT(DISTINCT if(TO_LOCATION LIKE 'INN_MONO_0*' and ((not([UOM for FROM_QTY.] like 'RC')) and FROM_LOCATION LIKE '1*'),TO_LIC

      ,0))

       

       

      Please advise.

       

      Thanks for your time.

       

      BR

      Dan