4 Replies Latest reply: Mar 16, 2016 3:30 AM by Eksa Susanto RSS

    GP % expression how to make it with out select current mth and yr ?

    PAUL YEO

      Hi All

       

       

      I have beow expression at table 1 working fine , when i select current month and year :-

       

       

      (

      sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales/$(Columndim89))/1

       

       

      -

      sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost/$(Columndim89))/1

       

       

      )

      /

      sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales/$(Columndim89))/1

       

       

      Can some one share with me how to make the above expression still working when i not select current month and current year ?

       

       

      Now Table 2 not working fine , because of above expression need to modify.

       

       

      Paul