5 Replies Latest reply: May 12, 2016 1:17 AM by asas asas RSS

    SetAnalysis QTD Problem

    asas asas

      Hi,

       

      My Below Expression is not working for QTD.

       

      SUM({<[A]={'Initial Charge'},

      [B]={'*'}-{'Premium'},

      [Billing Transaction Date]={">=$(=Date(QuarterStart(Max([Transaction Date]))))<=$(=Date(Max([Transaction Date])))"}

      >}

      [Transaction Amount])

       

      The above expression shows me the wrong data.

      Values for the field B  are 'Late Fee', 'Surcharges','Premium' and 'Taxes'.

      However, for current month 'Late Fee', 'Surcharges' does not exists. So the above expression gives me the data for month of may only. It is not summing up for April and May.

      For the month of April all the values for field B exist.

       

      Please help me with the same.

       

       

      Regards,

      Manu