3 Replies Latest reply: Oct 10, 2016 7:30 AM by Yeo Poh sai RSS

    May i know how to make it when i not select month = 9 , it will display 447 ? Now display 493

    Yeo Poh sai

      Hi All

       

       

      =SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)/1000

       

       

      When month = 9 , it display 447 K is correct.

       

       

      May i know how to make it when i not select month = 9 , it will display 447 ?

       

       

      This issue is because my GL data for sept is only available next week Oct 15. So i need to compare base on last month data. that is Aug data not Sept data.

       

       

      Paul