Within SSIS 2005 I am using the YTD function within a calculation of a cube.
Now I want to use a function which returns the sum of a field from the beginning untill now.
For example:
2006 Jan: 100
2006 Feb: 100
....
2007 Aug: 100
Time parameter: July 2007
YTD: 700 (7 months x 100)
All: 2000 (20 months x 100)
"All to Date": 1900 (19 months x 100. Untill July 2007)
Can someone help me with the right syntax for my "All to Date function?"
Thanks,
Frans
Now I want to use a function which returns the sum of a field from the beginning untill now.
For example:
2006 Jan: 100
2006 Feb: 100
....
2007 Aug: 100
Time parameter: July 2007
YTD: 700 (7 months x 100)
All: 2000 (20 months x 100)
"All to Date": 1900 (19 months x 100. Untill July 2007)
Can someone help me with the right syntax for my "All to Date function?"
Thanks,
Frans