Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try replacing the today() with makedate(2011,07,31)
Stefan
Stefan...YOU'RE AWESOME!!