2 Replies Latest reply: Jun 18, 2018 6:10 AM by Del Booth RSS

    Count number of distinct routes

    Del Booth

      Hi .

       

      I am trying to count the number of district routes for a given time ie current year and previous week.  I have tried the below where ColYear is master calendar data element and route is the field routes are located in.

       

      count(distinct(if(ColYear={"$(=year(Today()))"},ColWeek = {"$(=Week(Today())-1)"},Route)))

       

      Thanks

      Del