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