2 Replies Latest reply: Apr 12, 2016 8:16 PM by Sunny Talwar RSS

    How to add year = {$(=Max(year)-1)} into my count expression ?

    PAUL YEO

      Hi All

       

      I have below expression work fine :-


      count(distinct(company))

       

      I want to add, below condition to above :-

       

      year = {$(=Max(year)-1)}

       

      I try :-


      count(year = {$(=Max(year)-1)},distinct(company))

       

      it does not work.

       

      Paul