This discussion is archived
5 Replies Latest reply: Feb 14, 2013 3:45 AM by Srini VEERAVALLI RSS

previous quarter

976632 Newbie
Currently Being Moderated

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points