7 Replies Latest reply: Jun 17, 2015 1:16 AM by AVIRAL NAG

I want to Sum the value from one date to another date

Hi friends,

I wanna to sum the range of values from one date to another date.

Abinesh.S

• Re: I want to Sum the value from one date to another date

Hi,

R u giving a selection range for date. like from date and to date....can u post a sample

• Re: I want to Sum the value from one date to another date

This is my table I need to show the sum of Billing day from 01-01-2015 to 05-01-2015.

And am using this Exp "=sum({\$<Date={'01-01-2015','05-01-2015'}>} [Billing day]) " for that but I doesn't provide the exact result what I need.

I don't know how to get that value........

• Re: I want to Sum the value from one date to another date

Hi

If you need result on particular Date than Try this:

=sum({<Date={">=\$(='01/01/2015')<=\$(='05/01/2015')"}>}[Blling day])

Regards

Av7eN

• Re: I want to Sum the value from one date to another date

And one more thing in the above exp I got result "2" because it consider the dates value only whatever I highlighted in that exp

• Re: I want to Sum the value from one date to another date

For this create two variables in which it stores your start date and end date. Then use this expression:.,

=sum({<Date={">=\$(vStartDate)<=\$(vEndDate)"}>}Sales)

• Re: I want to Sum the value from one date to another date

If u want to do it with out variable using a hardcore date, then

=sum({<Date={">=('01-01-2015')<=('05-01-2015')"}>}Sales)

• Re: I want to Sum the value from one date to another date

Hi Abinesh,

Based on the requirement you can use ,if condition or set analysis to get the count.