0 Replies Latest reply: Jan 8, 2015 12:23 AM by Suresh Babu RSS

    YTD   MTD   WTD

    Suresh Babu

      Hi good morning 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 am using above expression for calculating total weight , that show total weight what ever i have in my data.

      But i need Total Weight based on YTD -- current year To Day

                                                       MTD -- current month To Day

                                                       WTD -- current week to Day (sun day to sat day)

       

      this values are shown in text object