Lee

Case(month(Somedate) > 6; year(somedate)) + 1; year(get(somedate)))

should give you a fiscal year.  Sort by that.

Stephen

----------

"We were promised a society of philosophers. But the Blogosphere is looking more and more like a nation of ankle-biters." --- Steven Levy

On Mar 23, 2011, at 5:50 PM, Lee wrote:

> I did something very similar in version 5 over 10 years ago but I'm sure the advancement of filemaker in that time would have a more efficient way of doing it now.
> 
> On 24/03/11 10:49 AM, Lee wrote:
>> Hi,
>> Its actually a little more complicated than that.
>> The 'years' are the financial years starting July to June each year. so the running totals would be for each financial period.
>> 
>> Lee
>> 
>> On 24/03/11 10:39 AM, Lee wrote:
>>> Hi,
>>> Thank you to Corn and Stephen for the answer to my last query on layout changes in 11.
>>> 
>>> I have a list of amounts ($) that have been entered during each year. I'd like to have a total (running) of each year's amounts.
>>> I have a separate field that identifies each year but how would I create an onscreen running total for each year.
>>> 
>>> Lee
>> 
> 
> --