5 Replies Latest reply: Jun 2, 2017 8:58 AM by Ruma Barman RSS

    Sum of previous sale not working with selection of one month

    Ruma Barman

      Hi All,

      Can anybody please help?


      I have an expression like

      (sum({<Link_Date={'$(vMaxDate)'}>}Sales)-sum({<Link_Date={'$(vPreviousDate)'}>}Sales))/sum({<Link_Date={'$(vPreviousDate)'}>}Sales) where vMax and vPreviousDate are variables defined respectively as =Date(Max(Link_Date),'DD/MM/YYYY') and =Date(monthend(Addmonths(max(Link_Date),-1)),'DD/MM/YYYY').

      This is working when no monthname is selected ,whenever one single month is selected it will show sum as 0 but will work when two month name is selected.