Hello,

I want to sum a measure for all time to the currently selected member of my
time dimension. Eg. Sales from All Period to April 2004 (if I selected
April 2004).

Here is the code I wrote:

iif([Measures].[Sales]=0,NULL,Sum(Periodstodate([Period].[(All)],[Period].cu
rrentmember),[Measures].[Sales]))



But it doesn't seem to do as expected. Help!

Try this and let me know how you get on:

iif([Measures].[Sales]=0,NULL,
Sum(Periodstodate([Period].currentmember.level, [Period].currentmember)
,[Measures].[Sales]))

Regards
Jamie

"AshVsAOD" wrote:

Thanks... But doesn't quite do as expected...

Here is an example:

2004 Sales = 5000
2005 July Sales = 3000

If I select July 2005 as the time member I want a running total of all sales
up to July... So the amount should be 8000.

I am positive Periodstodate is the correct expression... But... HELP!!!
"Jamie" <Jamie (AT) discussions (DOT) microsoft.com> wrote

I believe this could be the answer:

Sum({OpeningPeriod ([Period].[(All)],
[Period].Currentmember):[Period].CurrentMember},[Measures].[Wiptime])

"AshVsAOD" <.> wrote