9 Replies Latest reply: Jan 1, 2013 11:31 PM by Suri K

# Range

Dear all

user selected  the from date to  two date  then should show the values

• ###### Re: Range

Hi,

take two input box inside that  create a variable.

vStartDate

vEndDate

try this Exp

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

Regards,

Nirav Bhimani.

• ###### Re: Range

thank for uer   reply  but   it showing   incorrect  dates  like 30-DEC-1988 ,please check it and send me  once

• ###### Re: Range

Hi,

Check your date format and use this expression it works.

=Sum({<DateNum={">=\$(=vStartDate)<=\$(=vEndDate)"}>}Sales)

Regards,

Jagan.

• ###### Re: Range

Hi,

Try this,

=sum({<SHKZG ={'S'}, DateNum={'>=\$(=Num(vStartDate))<=\$(=Num(vEndDate))'} >} MENGE)

Regards,

Jagan

• ###### Re: Range

Hi surik147

My expression is working.please find the attachment.

Regards,

Nirav Bhimani

• ###### Re: Range

Hi,

Regards,

Jagan.

• ###### Re: Range

Hi,

=(sum({<SHKZG ={'S'}>} MENGE)) - (sum({<SHKZG ={'H'}>} MENGE))-----------openin

Regards,

Jagan.

• ###### Re: Range

Hi,

Regards,

Jagan.

• ###### Re: Range

hai

=if((Datefield) < startdate ,(sum(if(ABC ='C,'XYZ))) - (sum(if(ABC ='D',XYZ))))

same  expression  i need in   set analysis

Regards

surik147