9 Replies Latest reply on Apr 25, 2018 9:39 AM by Hari Ankem

    Last Year Calculation (Different Fiscal Year)

    Fernando Souza

      Dear all,

       

      In my company, the fiscal calendar is very different. Knowing this, a calendar table was created in the database, where I have:

       

      Column and Example

       

      • Revenue = 300,000.00
      • Order Date = 20180420
      • CA Year ID = 2018
      • CA Semester ID = 20181
      • CA Quarter ID = 20181
      • CA Month ID = 201802
      • CA Week ID = 201807
      • CA Day of Month ID = 19
      • CA Day of Week ID = 5
      • LY Order Date = 20170421
      • CA LY Year ID = 2017
      • CA LY Semester ID = 20171
      • CA LY Quarter ID = 20171
      • CA LY Month ID = 201702
      • CA LY Week ID = 201707
      • CA LY Day of Month ID = 19
      • CA LY Day of Week ID = 5

       

       

      I know that in 20170421 (last year) the Revenue was 250,000.00. But, I dont know how to create the field Revenue LY to compare the values.

       

      How can I do this?