Expression

[sakamsureshbabu]

Hi

i have below Exp

in that {[BILL DATE] >= 'Start',[BILL DATE]<='End' is used for starting and end date selection.

but it showing error How can write this..

(sum({<DETAILENTRYTYPE = {'B'}, CANCELLED = {'N'}, ESTIMATE = {'N'} ,{[BILL DATE] >= 'Start',[BILL DATE]<='End'}>}DETAILSTONEWEIGHT))

[sushil353]

Hi,

Try Below

Sum({<DETAILENTRYTYPE = {'B'},CANCELLED = {'N'},BILLDATE ={" >=$(Start) <= $(End) "} >} DETAILSTONEWEIGHT)

HTH

Sushil

[its_anandrjs]

Hi,

I assume Start and End is the variables then write like

= Sum({<DETAILENTRYTYPE = {'B'}, CANCELLED = {'N'}, ESTIMATE = {'N'} ,

   [BILL DATE]  ={ ' >=$(Start)  <= $(End) ' }>}DETAILSTONEWEIGHT)

Regards

Anand