Data Not Updating

[kcaron]

I have a field that uses the following formula:

(myseries-@cummean(myseries,"1999m12 2019m12"))/@cumstdev(myseries,"1999m12 2019m12")

Eviews created the date range when I created the formula and "hardcoded" it so that I have to update it manually every month. This takes lots of time.

I would like to have the range equal to the entire series so long as there is data available. In other words, so that I don't have to keep updating the formula one at a time for each calculated series.

Is there a way to change this formula so that the date range is not "hardcoded?"

Thank you!
KC

[EViews Gareth]

Could try "if myseries<>na" as the sample

[kcaron]

Works perfectly!

Thank you!