Hi,
I've got the reuslt I want, which is a monthly average but I'm not sure if there's a better way, first I'm getting the avarage using ;
![]()
Please Login or Register to view this content.
And then Calculate ;
Is there a better or alternate way of doing this, also I did try using variables but that didn't work I'm preusuming due to not being affected by the calculation filters.![]()
Please Login or Register to view this content.
Example attached.
Richard.
Bookmarks