Hi,

maybe this question was asked before... but I didn't find the solution...

I know about ytd(). This gives you i.e. an amount summed up over the year.
What I need is a somehting like a td(), so the sum of everything till today
(better: the current date). The problem is to set up a Balance Sheet on a
fact table which doesn't give you balance i.e. per month but each posting.
So the current balance is the sum of all postings since the start of the
business...

What can I do?

Thanks,


Thomas

Well this is then a range of the first date till selected one.

you can specify in MDX range. Lets say that time dimension starts with
1.1.2000 and you want to see the sum of all dates till selected one - but in
this case the selected one must be in level Days -> you have to make rules
for levels.

{[Time].&[2000].&[12].&[21]:[Time].currentmember}


HTH,
Andrej


"Thomas Pagel" <tpagel (AT) _nospam_ (DOT) software4you.com._nospam_> wrote

Andrej,

thanks, this works perfectly... But only, if you have a posting on the
currentdate... If that member is empty, it returns NULL... Any idea for
that?

Thanks again



Thomas

"Andrej Hudoklin" <andrej.hudoklin (AT) add (DOT) si> schrieb im Newsbeitrag
news:O75PSe25EHA.1260 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Hi,

I found a solution on myself... It's quite slow but it works...

sum({head(
FILTER({[Date].[Year].&[2003].&[2].&[4].&[20030401] :
[Date].CURRENTMEMBER}, NOT ISEMPTY([Measures].[Amount]))).ITEM(0):
TAIL(
FILTER({[Date].[Year].&[2003].&[2].&[4].&[20030401] :
[Date].CURRENTMEMBER}, NOT ISEMPTY([Measures].[Amount]))).ITEM(0)}
,[Measures].[Amount])


Thomas
"Thomas Pagel" <tpagel (AT) _nospam_ (DOT) software4you.com._nospam_> schrieb im
Newsbeitrag news:%23r8TxYA6EHA.824 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Is there any reason you use head and tail? I think following expression give
you the same results.

SUM(
FILTER(
{[Date].[Year].&[2003].&[2].&[4].&[20030401] :
[Date].CURRENTMEMBER},
NOT ISEMPTY([Measures].[Amount])
),
[Measures].[Amount]
)


Ohjoo Kwon
www.olapforum.com



"Thomas Pagel" <tpagel (AT) _nospam_ (DOT) software4you.com._nospam_> wrote

Hi,

sounds good... I'll give it a try when I'm working on that project again...
Requirements changed so it's not so urgent anymore... But thanks for the
feedback!


Thomas


"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> schrieb im Newsbeitrag
news:%23G3kaRa6EHA.2180 (AT) TK2MSFTNGP10 (DOT) phx.gbl...