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

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

Thanks,

Vandana

• ###### 1. Re: last day of the data by for each month including current month

Hi Vandana,

Here it is. Your data has 7th April as Last day of this Month.

These are the Calculations:

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to Close Thread.

1 of 1 people found this helpful
• ###### 2. Re: last day of the data by for each month including current month

Hi Vandana,

You could try adding an additional condition to return the total if date = the max date in the dataset.  I think something like below should work.  Let me know if you have any questions.

Regards,

Ivan

if [EOM]=[Date] THEN [Totals]

ELSEIF [Date] = {MAX([Date])} THEN [Totals] END