5 Replies Latest reply: Feb 14, 2013 5:45 AM by Srini VEERAVALLI RSS

    previous quarter

    976632
      Hi

      my script is

      CASE WHEN "Periods"."Period year" = YEAR("Periods"."Quarter start date")

      and "Periods"."Quarter num"= QUARTER_OF_YEAR("Periods"."Quarter start date")-1 THEN "Facttable"."Net amount" ELSE 0 END


      im using in editscript

      it show all 0

      why its not give the previous quarter