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

    Set analysis help!

    Samuel Vile



      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