根据条件计算净额 [英] Calculate net amount based on conditions

问题描述

根据条件计算净额

________________________________________

我需要计算基于FedRatio的净额。通常情况下，FedRatio设置为80％，但有一些情况会根据GrantNo和ProjectNo而变化。要将APAmount转换为NetAmount，我需要合并这些标准。


如果我有2张APAmount 100美元和200美元的发票，这些属于两个不同的美联储比率的项目（80 ％和90％） - 我需要弄清楚如何计算80美元和180美元的净额。授权号码保持不变。如果我在报告中创建txtNetAmount，它的控制权将是什么公式？这是指对报告的控制。现在我的报告基于一个基于两个表的查询（见下文）。


表名：tblAP

APAmount：货币

GrantNo：文件

ProjectNo：文字


表名：tblGrantBudget

美联储比率：FedRatio（百分比）


任何人的指导？谢谢。

Calculate net amount based on conditions
________________________________________
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 instances where it varies depending on a GrantNo and ProjectNo. To convert APAmount to NetAmount, I will need to incorporate these criteria.

If I have 2 invoices for the APAmount $100 and $200 and these belong to two projects with two different fed ratio (80% and 90%) – I need to figure out how to calculate the Net Amount of $80 and $180. The grant number remains the same. If I create txtNetAmount in my report, what formula will be in its control? This refers to a control on report. Right now I have based the report on a query that is based on two tables (see below).


Table Name: tblAP
APAmount: Currency
GrantNo: Text
ProjectNo: Text

Table Name: tblGrantBudget
Fed Ratio : FedRatio (Percentage)

Any guidance anyone? Thanks.

推荐答案

100和

200这些属于两个不同进给率的项目（80％和90％） ） - 我需要弄清楚如何计算净量

200 and these belong to two projects with two different fed ratio (80% and 90%) – I need to figure out how to calculate the Net Amount of

80和

这篇关于根据条件计算净额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！