9 Replies Latest reply: Apr 9, 2018 2:34 PM by Sunny Talwar RSS

    Year Comparison

    Arjun Madhusudan

      I am using below equation to find shops opened before selected year and closed after selected year.

      CreatedYear  is the year of opening year of shop

      ClosedYear is the year of closing year.

       

      As multiple year selection can be made in filter, we have used max to find the latest year selected.

       

      Also how to add shops/ outlets which are having closedyear = NULL

       

       

      Count({

      $<

      CreatedYear = {"<= $(max('Year'))"},

      ClosedYear = {">= $(max('Year'))"}

      >  } Distinct OutletID)