6 Replies Latest reply: Feb 20, 2017 1:34 AM by Royce Tang RSS

    Selecting previous year with current selection

    Royce Tang

      Dear experts,

       

      I have a question to ask regarding how I can select a previous year selection with a current set analysis selection which i have already made. Having looked and tried other solutions on the forum they were specific for the problem and I could not find a general solution where I was able to use, can anyone please help me out with this issue?

       

      My code is as of such,

      Sum({$<BDF_Type={"*Revenue*"}> * $<[fiscal year]-1> }cash)

       

      What I am trying to achieve is to select all the BDF type with the characters revenue as well as the previous fiscal year selection. The reason why i used the " * "  because I thought it would be a union set, but I am very sure that syntax is used wrongly in this context.

       

      The fiscal year date format is given as 2010,2011,2012 etc.

       

      Kind regards,

      Royce