Jump to content
  • 0

Calculate Percentage and Fees and Insert Results Into Non-Formula Field



I have a table that contains the following fields: grossamount, transactionfeepercentage, transactionflatfee and netamount. The grossamount field amount varies. The transactionfeepercentage field is always 2.9%. The transactionflatfee is always $0.10. The netamount field = grossamount -2.9% - $0.10  

The problems I am having are calculating the percentage and then inserting having that correct amount inserted into a non formula field so that I can use the data in other calculations. Any ideas on how to do this?  I am assuming that I will need a statement in my datapage which I do not know how to do. All help is appreciated.


Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...