Values between range

[praveenkumar_s]

Hello to all genius,

     I have one date column and sales column, If i select from and to date , the sum of sales between the dates must be shown. How can i done pls let me know..

[avinashelite]

Create 2 variables for the start and end data ...

vStartdate

vEnddate

then if(date>=vStartdate and date<=vEnddate,Sum(Sales))

or

sum({<date={>='$(vStartdate)'<='$(vEnddate)'}>}Sales)