4 Replies Latest reply: May 25, 2016 7:30 PM by Sunny Talwar RSS

    My SET expression on work for year 2016 , How to get 404k for dec 20125 ? Now display 0

    PAUL YEO

      Hi All

       

       

      I have below expression work fine for April 2016 current month sales :-

       

       

      =num(sum(

      {

      $

      <

       

       

      year = {$(=max(year))},

      month =

       

       

      {

      "<=$(=max(

      {

      <year={$(=max(year))}>

      }

      month)-0)>$(=max(

      {

      <

      year={$(=max(year))

      }

      >

      } month)-1)"

      }

       

       

      >

      }

      sales), '$#,##0;($#,##0)')

       

       

      My issue is when i change my current month = march 2016 , may i know how to make Dec 2015 display as 404K ?

       

       

      Paul