14 Replies Latest reply: Mar 14, 2014 1:58 AM by Jonathan Dienst RSS

    why is not ok for same expression.

      the express is ok :

      :   COUNT({<SHOPKEY= {"=(sum(SALES>0)"}  DISTINCT SHOPKEY)     is ok .

      the same :

          COUNT({<SHOPKEY= {"=(sum(year={"$(=max(year)-1)"}SALES>0)"}  DISTINCT SHOPKEY)   isn't ok ,why ?

       

      I want to get the number of shop which  have  sales in the the two year's same monthes .

       

      example:

         sales     201401   201301      count(result)

      shop1      234        230           1

      shop2      0            230           0

      shop3       344         0              0

       

      how to write  it in table?