Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
maybe this:
count( {< ColYear={"$(=year(Today()))"},ColWeek = {"$(=Week(Today())-1)"} >} DISTINCT Route)
Thanks