Range

[#1]

Dear all

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

[nirav_bhimani]

Hi,

take two input box inside that  create a variable.

vStartDate

vEndDate

try this Exp

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

Hope this will help you.

Regards,

Nirav Bhimani.

[jagan]

Hi,

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

Regards,

Jagan.

[#4]

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

[jagan]

Hi,

Check your date format and use this expression it works.

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

Regards,

Jagan.

[jagan]

Hi,

Try this,

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

Regards,

Jagan

[nirav_bhimani]

Hi surik147

My expression is working.please find the attachment.

Regards,

Nirav Bhimani

[jagan]

Hi,

Please find attached file.

Regards,

Jagan.

[jagan · Accepted solution]

Hi,

Regards,

Jagan.

[#10]

hai

thank you   for uer  reply

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

same  expression  i need in   set analysis

Regards

surik147