YTD MTD

[#1]

Hi to all,

(sum({<BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)
-
(sum({<BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)
-
(sum({<BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}, URDPURCHASE = {'Y'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

I taken label name as " Gross Weight" for above expression...please help me

I want find out YTD,MTD& WTD for above Expression.

How can I do???

Please help me out this issue.

Thanks in Advance.

regards

Chandra.

[ravindraa]

Hi Chandra Reddy,

   please find the below expression for WTD

=

sum({<date={">=$(=max(weekstart(date)))<=$(=max(weekend(date)))"}>}sales)

please modified date field and sales field then with out selction you can get the WTD values.

[#3]

Hi Rivindra,

Thanks for your reply.

it is not working ravindra

[jagan]

Hi,

What do you mean by "Without any selection"?  Do you want to ignore all the selected values?

If yes then use 1 in set analysis expression

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

-

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

-

(sum({1<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')

Hope this helps you.

Regards,

Jagan.

[ravindraa]

Hi Chandra Reddy,

  what Jangan Mohan is posting right, follow his expression then you will get value.

thanks &regards

A.R.Reddy