Jump to content

gain or loss between sucessive reccords

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

Recommended Posts

I use the following calculation to determine the investment gain or loss between two successive records. The records are sorted by date descending.


( Get(RecordNumber )>1;Total investment-GetNthRecord ( Total investment;Get(RecordNumber) -1 )


The calculation works well except that on the last record in the found set it results in a question mark. How can I eliminate the question mark? I would like the result to be be empty.

Link to comment
Share on other sites

Sorry about that. I changed the calculation after I posted it. ! It is:

( Get(RecordNumber ) ≥ 1;Total investment-GetNthRecord ( Total investment;Get(RecordNumber) +1 )

It determines the difference between the current and next records.

The file is attached.


Link to comment
Share on other sites

Well, if you're on the last record, then this part:

GetNthRecord ( Total investment ; Get(RecordNumber) +1 )

will error out.

You should change your test from:

Get (RecordNumber) ≥ 1


Get (RecordNumber ) < Get (FoundCount)

That will make the last record empty and return a value for the first record (which does have a next record).

Link to comment
Share on other sites

This topic is 1809 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

  • Similar Content

    • By cbum
      Any Experience running FMS 16 on Big Sur?
      What about 15/16/17 clients?
    • By ahum
      Hi, my FMP server 13 PC crashed, I want to reinstall the Server but keep getting the APR not able to download problem, just like everybody else, just wonder does any one resolve this issues?
    • By Philip Sommers
      I currently administer a Filemaker 16 Server and only use Oracle Java for the admin console (web publishing is turned off). We want to get rid of Java rather than start paying for it. Rather than upgrade to FMS18, is it possible to use OpenJDK instead of Java for the FMS16 admin console? If so, is there anyone that can provide some guidance on how to do that?
    • By jjjjp
      After upgrading to FM Server 16, I am seeing that the automatic daily script executed from the server side is no longer doing so without error. The script sends email reminders to workshop presenters scheduled within 4 days. The error code, which I record in a log, is 119. However, that code isn't listed among the error codes listed in the online help:
      Knowing the meaning of the error may provide useful information that will help me reconfigure the email account settings for the command Send Via SMTP Server.
    • By "... you mean these fans?"
      Mr. Ignoramus
      We have a solution in Canada where we moved the db from a hosting company to a LAN ( customers building ) They are using a Mac OS machine running FileMaker 16 server.
      We access the FM 16 server via apple's remote access, having trouble locating where we would put the index.html and php files for our web form that we used when we were hosting on an outside hosting company.  The hosting company put the html/php file in the folder that designated our account number. 
      My question is this ... where would we put the two web files; index.html (form) and the .php (create record in FM) file on the FM 16 server.  I can not seem to locate the instruction via the documentation FM is providing.  Have done several internet search ...
      I am gathering information to pass to the individual helping us with the FM server at location.
      Anybody able to provide a link or guidance I would be grateful.
      Thank you.
  • Create New...

Important Information

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