WTD

[#1]

Hi to All,

For following expression i want get the WTD value in Text Object.

I am getting the values if i select.

But without Selection i want get the Present Month Week to date value in the sense feb month

i have the date field from  Apr/01/2014 to Mar/01/2015.

But i have the data from Apr/01/2015 to Feb/05/2015.

How Can i get this please help me out this issue.

Following is my expression.

=Num((sum({<Year=, Quarter=, Month=, Week=, [BILL DATE]=,BILLDATE={">=$(=Date(WeekStart(Max(BILLDATE)-1)))<=$(=Date(Max(BILLDATE)))"}, BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Year=, Quarter=, Month=, Week=, [BILL DATE]=,BILLDATE={">=$(=Date(WeekStart(Max(BILLDATE)-1)))<=$(=Date(Max(BILLDATE)))"}, BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Year =, Quarter=, Month=, Week=, [BILL DATE]=,BILLDATE={">=$(=Date(WeekStart(Max(BILLDATE)-1)))<=$(=Date(Max(BILLDATE)))"}, BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}, URDPURCHASE = {'Y'}>}BILLDETAILGROSSWEIGHT)/WeightFlag),'##.00')

Thanks in Advance.

Regards

Chandra