Sum the amount from a range of date

[gauravgg]

hi

i have a following variables

vmincamp =date(min(Cdate),'DD/MM/YYYY')

vmincamp2=date(interval(min(Cdate) + 2,'D'),'DD/MM/YYYY')

According to my application these variables contain the following values

vmincamp= 01/01/2016

vmincamp2=03/01/2016

I want to write an expression which will sum the Orderamount  range from vmincamp to vmincamp2

ie sum of Orderamount from 01/01/2016 to 03/01/2016

How to write the expression ?

[Chanty4u]

=sum({ <$(vmincamp)+$(vmincamp2)>}Orderamount  )

[Anonymous]

sum({<Cdate={'>=$(=vmincamp)<=$(=vmincamp2)'} >}Orderamount)

[gauravgg]

hi rgv

it is showing following error in Textboject

Error:Error in set modifier ad hoc element list: ',' ro ')' expected

[maxgro]

if the Cdate field and the variables have the same format

sum({<Cdate={">=$(vmincamp)<=$(vmincamp2)"}>} Orderamount) 

[Chanty4u]

replace single quotes to double

[gauravgg]

hi , maxgro

no it showing the sum as 0 which is wrong

can u help me

[jagan]

Hi,

Try like this

=sum({<Cdate={'>=$(=vmincamp)<=$(=vmincamp2)'}>} Orderamount)

Regards,

Jagan.

[jagan]

Note Cdate and variables date format should be in the same format.  Otherwise the expression won't work.

Regards,

Jagan.