3 Replies Latest reply on Nov 5, 2018 7:37 AM by Daniel Ferreyra

# Eanother Easy Question: Select data of last day of a month

Hello Data Lovers,

I would like to know how to create a calculated field to select the data of the last day of a month. For example: How do i select yellow and blue data, Once selected i want to divide yellow/blue.

I attach my workbook, please feel free to edit it. (Im working on the Mileage balance sheet.

• ###### 1. Re: Eanother Easy Question: Select data of last day of a month

Hi Daniel,

Create a new Calculation with this formula SUM( IF  [Date] =  {MAX([Date])} then       [Mileage Accumulated]  end )

Cedric

• ###### 2. Re: Eanother Easy Question: Select data of last day of a month

Like this?

Create two calculated fields:

1. {FIXED YEAR([Date]),MONTH([Date]): SUM(IF [Date]= {FIXED YEAR([Date]),MONTH([Date]):MAX([Date])} THEN [Mileage Accumulated] END)}

2. {FIXED YEAR([Date]),MONTH([Date]): SUM(IF [Date]= {FIXED YEAR([Date]),MONTH([Date]):MAX([Date])} THEN [Plan Accumulated] END)}

• ###### 3. Re: Eanother Easy Question: Select data of last day of a month

Hey Ombir!