Set analysis help!

[samvile18]

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

[swuehl · Accepted solution]

Try replacing the today() with makedate(2011,07,31)

Stefan

[samvile18]

Stefan...YOU'RE AWESOME!!