Jump to content

Show only latest value in list for a year


laguna92651

This topic is 3006 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have added an additional TO to sum the withdrawals in a set of financial records by year, Withdrawal YTD column. I would like to show the yearly Withdrawal YTD sum in the last record of the year only and be blank in all of the other months in the given year, it may be Dec 31 or may not. All of the records would still be there, only some the values in the Withdrawal YTD column would be blanked. In this example only these values would show in the Withdrawal YTD column.

Dec 31, 2008   $8,000

Dec 31, 2009   $9,000

Dec 31, 2010   blank

Dec 31, 2011   $10,000

Dec 31, 2012   $11,000

Jul 31, 2013  $12,000

Before data below.

Withdrawals.png

Edited by laguna92651
Link to comment
Share on other sites

27 minutes ago, laguna92651 said:

I would like to show the yearly Withdrawal YTD sum in the last record of the year only

I believe the sensible thing to do would be to summarize the records by year and show a summary field (Total of Withdrawals) in a trailing sub-summary by year part - i.e. after the last record of the year.

 

27 minutes ago, laguna92651 said:

I have added an additional TO to sum the withdrawals

I am afraid that makes no sense to me at all.

 

Edited by comment
Link to comment
Share on other sites

I thought of that, but I just want to keep a continuous list of records with out any breaks. There are alot of columns, and maybe down the road when I get a good handle on what data is really important to me.

"I am afraid that makes no sense to me at all."

What didn't make sense is there a better way to summarize the years withdrawals without using a summary field?

Link to comment
Share on other sites

4 minutes ago, laguna92651 said:

but I just want to keep a continuous list of records with out any breaks.

Well, it is possible, but it will cost a bit in terms of performance. Just hide the summary field when the next record's year is the same as the current record's.

 

6 minutes ago, laguna92651 said:

What didn't make sense is there a better way to summarize the years withdrawals without using a summary field?

No, of course not. But it makes no sense to add a TO for this purpose.

Link to comment
Share on other sites

3 hours ago, laguna92651 said:

don't I need a TO for that?

No. At most, you need a layout for the report and maybe a script to go that layout, find the desired records and sort them.

 

3 hours ago, laguna92651 said:

If not how would I do that?

See if the attached example works for you.

 

YearlyTotal.fp7

Edited by comment
Link to comment
Share on other sites

Worked great, thanks.

Is there a way to modify the approach so I don't have to sort on cJan? Ideally, I would like to keep records sorted by ID, in case a date is miss-entered, wrong year entered. If an incorrect date is entered it can easily be seen as being out of order, if it is sorted by cJan the incorrect date will just fall into the sort date order and may not be noticed.

Link to comment
Share on other sites

3 hours ago, laguna92651 said:

Worked great, thanks.

Is there a way to modify the approach so I don't have to sort on cJan? Ideally, I would like to keep records sorted by ID, in case a date is miss-entered, wrong year entered. If an incorrect date is entered it can easily be seen as being out of order, if it is sorted by cJan the incorrect date will just fall into the sort date order and may not be noticed.

I would see that as a data entry issue, rather than a reporting issue.

I have a similar issue I deal with in people's time sheets, where they need to make sure their previous entry ends at the time for the next entry's start time - and I use some conditional formatting to highlight the entries that may be incorrect. And I apply it in the standard data entry mode, not on the end of week reports...

 

Edited by webko
Link to comment
Share on other sites

Worked great, thanks.

Is there a way to modify the approach so I don't have to sort on cJan? Ideally, I would like to keep records sorted by ID, in case a date is miss-entered, wrong year entered. If an incorrect date is entered it can easily be seen as being out of order, if it is sorted by cJan the incorrect date will just fall into the sort date order and may not be noticed.

Using conditional formatting is a great input to deal with the data entry task, thanks.

 

Link to comment
Share on other sites

This topic is 3006 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.