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




      Total Sales on the bar chart


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

      Any suggestions would be helpful.