Calculation of sum of sales between range?

[priyav24]

Hello Everybody,

                     I have a requirement where i need to to get sum(SalesNetPrice) between two month-year field ,

between Start_Year and End_Year.

i.e)Start_Year have values "Jan-2013" corresponding "End_Year"  have values "Dec-2013 ".

                       I need to calculate sum( SalesNetPrice) .with condition SalesDate_MonthYear in the range start_Year and End_yea

     Currently am tried the below expression which is not working

Expression :

=Sum({<SalesDate_MonthYear={">=$(StartYear) <=$(EndYear)"}>} SalesNetPrice)

Thanks in Advance,

Priya

[#2]

try this:

Sum({<SalesDate_MonthYear={">=$(=date(StartYear)) <=$(=date(EndYear))"}>} SalesNetPrice)

[salto]

Hello,

sum ({<SalesDate_MonthYear= {"<=$(=date(EndYear))>=$(=date(StartYear)"} > } SalesNetPrice)

Maybe using the date() function may help in this case.

Regards.

[priyav24]

No its not working since Start & End Year are not date field.

[salto]

Hi,

what type of fields are they?

[#6]

try this then:

Sum({<SalesDate_MonthYear={">=$(=date(StartYear),'MMM-YYYY') <=$(=date(EndYear),'MMM-YYYY')"}>} SalesNetPrice)

[amitarusi]

which values do you have in SalesDate_MonthYear  ?

[saumyashah90]

StartYear and EndYear are variables...so change their definition

Date(min(Datefield),'MMM-YYYY') as StartYear

Date(max(Datefield),'MMM-YYYY') as EndYear

and then try that

[priyav24]

The Values in SalesDate_MonthYear  are 'Jan-2004'...'Oct-2013'

[amitarusi]

so the values in startyear and endyear should be the in the same, if not you can change their format using makedate,