Jump to content

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

Recommended Posts

Here's a link from Filemaker's support knowledge base:

http://help.filemaker.com/app/answers/detail/a_id/8389/related/1/session/L2F2LzEvdGltZS8xNDYwMDU0Mjg1L3NpZC9GSm80R3JObQ%3D%3D

I have this calculation below in an 'Opening Balance' field but it doesn't work after 29 records. Is there any work around for this?

If( Get ( RecordNumber )=1;combinedRecords_GL Accounts_AccountExport::Bal Fwd;GetNthRecord ( Closing Balance ; Get ( RecordNumber ) - 1 ))

Link to comment
Share on other sites

  • 2 weeks later...

I can't get summary fields to do what they should either and I believe from Filemaker's site that this function is the correct one for what I want to do. I've attached a file as an example of the issue. It does exactly what it should until the 72nd record then '?' marks start to appear. If you click in the question mark the correct value appears at record 73 but at record 74 you can't even click in the fields. I think this is a bug. Any one have any ideas?

Test.fmp12.zip

Link to comment
Share on other sites

Two things. Get nth record should be a robust calculation as well and has the advantage that it can refer to the field being accumulated AND to other fields as well. So it has strengths. 

 

I've been in touch with filemaker and they have concluded that this is a bug and they will be working on it for a solution. 

Now as for summary fields I've attached a file. I hope someone will straighten me out here.

 

The numbers make no sense to me. Thanks in advance.

Summary Test.fmp12.zip

Link to comment
Share on other sites

Bruce that solved the getnth record question marks at record 72 as well. Many thanks.

 

The last issue is that I need there to be a category and I need the calculation to start fresh with each change in the category. So in your solution the PriorLineRT does not do this. I think the calculation needs to figure out if it is the first record in a category grouping. Can you think of a way to do this? Or a way to start the PriorLineRT as zero in the first record of each grouping?

Link to comment
Share on other sites

For others who may read this thread and find it helpful, which is what it's all about, here's a 3rd version of your file with the calculations in it that figure out what record in each group a record is, either the 1st or anything else and calculates to 0 if it is the first.

TestMOD3BFR.fmp12.zip

Edited by Ocean West
context
  • Thanks 1
Link to comment
Share on other sites

This topic is 2262 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
 Share

×
×
  • Create New...

Important Information

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