2 Replies Latest reply on Jul 24, 2016 9:57 PM by Mahfooj Khan

    CurrentYear vs Lastyear comparison

    Michael Jo

      Dear experts,
      i have created a parameter named year and 2 calculated fields with Superstore sorces including:
      SalesCY:  if [year]=YEAR([Order Date]) then [Sales] END

      SalesLY:   if [year]=YEAR([Order Date]) +1 then [Sales] END


      Now, i create a new calculated field:

      %LY = SalesCY/SalesLY


      However, it was unable to show value for %LY, Could anyone give me some advices to comapre SalesCY and SalesLY?


      Best regards,