Hi, All
I have a problem that is calculate IYA (index year ago) Vol in next chart for each month in chart
So, not long thinking decided to use RangeSum()
IYA=RangeSum(Month2017)/RangeSum(SameMonth2016)
RangeSum for Months 2017:
RangeSum(After(Sum({< $(vSetYTD)>Vol),0,$(=Max(PeriodID) -60))) work right with result in line 2017
RangeSum for Months 2016:
RangeSum(After(Sum({< $(vSetLYTD)>Vol),0,$(=Max(PeriodID) -48))) work not right with result in line 2016 (Total 48 908).
Everything went well until Month = 'авг' from this month RangeSum will reflect incorrect result - 48 908 that which began to repeat from month to month until the end of the year.
It's QV bug? Whats wrong with my code?
Many thanks to everyone who cares about other people's issues!
Vadim