Mime-Version: |
1.0 (Apple Message framework v1082) |
Content-Type: |
text/plain; charset=us-ascii |
Date: |
Wed, 23 Mar 2011 17:59:52 -0600 |
Reply-To: |
|
Subject: |
|
From: |
|
In-Reply-To: |
|
Content-Transfer-Encoding: |
quoted-printable |
Sender: |
|
Parts/Attachments: |
|
|
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
>>
>
> --
|
|
|