4 Replies Latest reply on Dec 27, 2018 6:33 AM by Lucas Rencoret

# division of values in range of dates

Hi,

Is there a way to define a range of dates, and then divide the values of those dates?

For example: date range 01-01-2015 & 20-01-2015, divide 1.209,812 / 1.207,810 = 1,0016575

Thanks!

• ###### 1. Re: division of values in range of dates

Good morning

see the attached

first add the date to context on the filter shelf

next the formula for total is

then the percentage is

it returns this with the data in your post

or this when you filter the dates

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: division of values in range of dates

I need to make the division of only the first and last value.

At / A0

• ###### 3. Re: division of values in range of dates

sorry

see attached

determine min and max dates

min max values

and percent

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 4. Re: division of values in range of dates