Jump to content
  • 0
Sign in to follow this  
DaveC2019

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

Question

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.

DepositTableTEST.zip

Share this post


Link to post
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.

Guest
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.

Loading...
Sign in to follow this  

×
×
  • Create New...