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

[#1]

Hi friends,

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

Like sum of values from 01-05-2015 to 12-05-2015. Please help me

Thanks in advance

    Abinesh.S

[help4qv123]

Hi,

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

[#3]

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........

[#4]

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

[help4qv123]

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

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

Where vStartDate=Your start date

vEndDate= Your end date

[help4qv123 · Accepted solution]

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

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

[avinashelite]

Hi Abinesh,

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

[aveeeeeee7en]

Hi

If you need result on particular Date than Try this:

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

Regards

Av7eN