YTD calculation
787296Aug 25 2010 — edited Aug 25 2010Hello:
I have a period table that has period values representing Month codes ( 1, 2,3,4,5,6,7,8,9,10,11,12, 0, 998, 999)
Yes..0, 998, 999 are also in the period values 0 representing previous year values summed up and 998 and 999 representing
other balance amounts.
When I calculate YTD on one column that has a value corresponding to period 0, the YTD value is not giving the correct values. I am so confused why I am seeing these values.
Along with this, the question I had is that when we calculate YTD using --> TODATE(some_column, year_level),
what values are summed up to give YTD value. I mean, for eg,
I have the following values:
Year Period Value
2010 0 100
2010 1 200
2010 2 250
2010 3 300
......
2010 8 500
1 representing Jan, 12 representing Dec and 0 has some thing defined and it has some values.
Now, if I do YTD -> TODATE(some_column, year_level), Then, the YTD value will be SUMMATION from
period 0 to current period or from 1 to current period. I am sure that I am missing some understanding
here in the YTD calculation. Can someone please share your inputs. Am unclear in this situation.
Thanks.