如果有处置，NBV为零 [英] NBV To Zero if There is Disposal

问题描述

我查询了以下字段cost，AccDpr，Disposal和NBV，我想做的是当它们是任何值，即处置字段中的金额时，将NBV返回到零。 NBV公式= [成本] - [Accdpr]。请帮助

I have a query with the following fields cost, AccDpr, Disposal and NBV, what i want to do is to returned NBV to zero when their is any value i.e amount in disposal field. The NBV formula = [cost]-[Accdpr]. Pls Help

推荐答案

Mafi，


我给你的第一个建议是，你永远不应该有一个计算字段作为一张桌子。应始终在使用其他三个值的查询或报告中计算MBV值。这消除了您当前的顾虑，MBV值始终是最新且准确的。


希望这个hepps！

Mafi,

My first advice to you is that you should never have a calculated field as part of a table. The MBV value should always be calculated in the query or report that uses the other three values. This eliminates your current concerns, and the MBV value will always be current and accurate.

Hope this hepps!

我所有的计算字段都在查询不是表的一部分。

All my calculated fields are in query not part of table.

这就像说：

Is this as simple as saying :

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

这篇关于如果有处置，NBV为零的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！