5 year groups

[javiersan]

Hello,

I want to calculate the 5y average of a quarterly series without having to copy it to a multi-year page with the "mean" option. The five year groupings are defined from "today" backwards as follows:
@meansby(x,@round((@obsrange-@trend)/60))

the problem is that @round rounds to the nearest integer and I need to extract the non-fractional integer without rounding (otherwise the first block is about 2.5 years not 5).

Could you please suggest a solution?

Thanks,

Javier

[EViews Gareth]

I don't follow what you're doing there, but don't you just want @floor rather than @round?

[javiersan]

Yes, floor does the job, thanks.