Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Hi,
Try Below
Sum({<DETAILENTRYTYPE = {'B'},CANCELLED = {'N'},BILLDATE ={" >=$(Start) <= $(End) "} >} DETAILSTONEWEIGHT)
HTH
Sushil
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