2 Replies Latest reply: Sep 1, 2011 11:32 AM by Sam Vile RSS

    Set analysis help!

      Hi,

       

      Can anyone help me please?

       

      I have the following syntax that I use to calculate a YTD Forecast figure, I need to change it so instead of it calculating up to todays date...it calculates up to 31/07/2011

       

      =Sum({$<Year = {2011},Measure={'Budget'}, Period={"<=$(=Today())"}>}Value)/1000

       

      Many thanks in advance