6 Replies Latest reply: Oct 21, 2015 6:10 AM by Colin Albert RSS

    My SET analysis expression return full year amount

    PAUL YEO

      Hi All

       

      I have below expression , i want it display LY YTD amount , it does not work , it display whole of last year amount , May i know where i go wrong ?

       

      sum({$<year = {$(=max(year)-1)}

      ,[Reporting Code] = {

       

       

      ">=00100<=

      00374"

           }

       

       

      , month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} Amount*-1/1)/1000