6 Replies Latest reply: Nov 6, 2013 12:21 PM by Vani Gade RSS

    How to ignore selection in a if Statement with Set Analysis?

      I have to calculate fiscal YTD? Our fiscal year starts from July to August. So, If i select Month = May 2012..then it has to calculate from July 2011- May 2012. I have the following formula, but the moment I select time dimensions, it filters that data to that month.

       

      =if(date(CalMonthYear, 'M')>= 7,

      sum (  {< CalMonthYear={">=$(=makedate(year(max(CalMonthYear)), num('7'))) <=$(=Max(CalMonthYear))"}, CalMonthYear=>} Direct_Cost),0)

       

      Any Help?

       

      Thanks.