5 Replies Latest reply on Feb 14, 2013 11:45 AM by SriniVEERAVALLI

    previous quarter


      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