2 Replies Latest reply on Apr 13, 2018 5:30 PM by Ivan Young

    last day of the data by for each month including current month

    Vandana Samtani

      Hi All,

       

      I need your help in a calculation to get data for last  day of the month and for current month it should be data as of 4/13/208.

       

      I am trying to show a summary bar chart of how many items has been sold by month and users also need current month.

       

      I can't do the sum of all days because every day the number changes. so just the last day of each month will be good to pick.

       

      The formula i was using gives me data until March 31st but not for April. the users are looking for April as of today in the bar chart.

       

      End of Month formula

       

      DATE(DATETRUNC('month',DATEADD('month',1,[Date]))-1)

       

      Total Sales on the bar chart

       

      if [EOM]=[Date] THEN [Total Sales] END

      Any suggestions would be helpful.

       

      Thanks,

      Vandana