By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,485 Members | 1,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,485 IT Pros & Developers. It's quick & easy.

Calculate net amount based on conditions

100+
P: 418
I need to calculate a net amount that is based on FedRatio. Normally the FedRatio is set to be 80% but there are a few instance where it varies depending on a GrantNo and ProjectNo. To convert APAmount to NetAmount, I will need to incorporate these criteria.

If I create txtNetAmount in my report, what formula will be in its control?

Table Name: tblAP
Fed Ratio : FedRatio (Percentage)
APAmount: Currency
GrantNo: Text
ProjectNo: Text

Any guidence anyone? Thanks.
Jun 10 '09 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,709
I'm not sure if this has been handled already in another thread M, but if you still need help you will probably need to explain the parameters that we're to work with.

It's not clear what relates to what here I'm afraid.
Jun 15 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.