14 Replies Latest reply on May 16, 2014 5:57 AM by Don Barnetson

    Calculate Previous Years Sales

    Frances Jones

      Hi, hope you can help

       

      I have a Sales Calculation for current year and previous year sales.

       

      The problem I am experiencing is that no matter what calculation I use, I'm always getting this Financial years Sales figures.

      I have a filter on the data so that it only shows FY2014, but then I want to create a calculation that shows the % To last years revenue + an uplift of a dynamic paramater (e.g  FY2013 Sales + 20% = 2014 Target)

       

      I've tried using this:

      If datediff('year', [Previous revenue_period], [revenue_period])=1 then [rev] end

      But this just returns the sales for the current Financial year.

       

      Any ideas on the best way to do this? I've had a search through the KB and forums.

       

      Thank you!