重新订购计算 [英] Re ordering a calculation

问题描述

我在商店和订购系统上的项目工作。

i已经计算出如何计算行总数，例如产品流程*数量。

i然后设法通过使用公式将一个订单的所有行总计相加


Order_Total：Sum（（Products.Price * [Qty_on_Order] *（1- [Discount]）/ 100） * 100）然后我尝试通过添加订单总数来执行最终成本，然后


这是在查询客户查询订单中完成的。

deivery成本，然后是整体折扣，两者都来自

表客户订单

这是在新查询中进行的。< b />
i尝试下面的那个


最终成本：总和（[客户查询订单]。订单_总计+（[客户订单]。[交货成本] *（1- [客户订单] .Overall_Discount）/ 100）* 100）


此工作除外，只有整体百分比仅适用于交付成本，然后添加订单总额。

但我希望这只适用于一次交付成本和订单总额加起来。

任何想法或提示？

i真的很感激，因为我正在努力重组这个公式

欢呼

i am worlking on my project on a shop and ordering system.
i have worked out how to calculate the line total, e.g product proce * qty.
i have then managed to add up all the line totals for one order by using the formula

Order_Total: Sum((Products.Price*[Qty_on_Order]*(1-[Discount])/100)*100)i then tried to execute the Final Costs by adding the order total, and then

this was done in the query "Customer Query making order"
deivery costs and then ontop of that the overall discount, both of which came from the
table "Customer Order"
this was doen in a new query.

i attempted the one below

Final Costs: Sum([Customer Query making order].Order_Total+([Customer Order].[Delivery Cost]*(1-[Customer Order].Overall_Discount)/100)*100)

this works except only the overall percentage only applies to the delivery cost,and then adds on the order total.
But i want this to apply only once both the delivery cost and order total are added up togehter.
Any ideas or tip?
i really would be thankful, as i am struggling to restructure this formula
cheers

推荐答案

最终成本：总和（[客户查询订单]。订单_总计+（[客户订单]。[交货成本] *（1- [客户订单]。整件_折扣）/ 100）* 100）

但我希望这只适用于一次交付成本和订单总计加起来。

欢呼

Final Costs: Sum([Customer Query making order].Order_Total+([Customer Order].[Delivery Cost]*(1-[Customer Order].Overall_Discount)/100)*100)

this works except only the overall percentage only applies to the delivery cost,and then adds on the order total.
But i want this to apply only once both the delivery cost and order total are added up togehter.
cheers

怎么样：

最终费用：总和（（[客户查询订单] .Order_Total +（[客户订单]。[交货成本]）*（1- [客户订单] .Overall_Discount）/ 100）* 100）

How about this:
Final Costs: Sum(([Customer Query making order].Order_Total+([Customer Order].[Delivery Cost])*(1-[Customer Order].Overall_Discount)/100)*100)

试试这个..

Try this ...

展开 | 选择 | Wrap | 行号

Tahnk你的帮助，但我担心这些都不起作用 -


迈克尔R发布的第一个与我的公式相同，但是将总订单的次数换算为100，然后加上交货成本（仅适用于交付成本，整个doscount是否适用）


和mmccarthy的第二个回复添加了订单总额和交付成本，但是将总数除以100，例如，而不是93.00英镑，它是0.93，然后当添加折扣时sa y 80％，然后总计每年的交付成本将占用百分比等于0.922


i非常感谢所有回复，请更多建议。

Tahnk you for your help but im afraid none of these work -

the first one posted by Michael R does the same as my formula, but instead times the total order by 100, and then adds the delivery cost(and only for the delivery cost does the overall doscount apply)

and the second reply by mmccarthy adds both order total and delivery cost, but instead divided the total by 100 e.g instead of ￡93.00 it comes as 0.93, and then when a discount is added say 80%, then the total in luding delivery cost will take away the percentage amount to equal 0.922

i am very grateful for all you replies, any more suggestions please.

这篇关于重新订购计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！