一個例子:客戶在銷售訂單行項目上建立了一個擴充字段A,這個字段的值是最終使用者手動輸入的:
An example: Suppose customer has already created one extension field named “Special Net Price” on Sales Order item level.
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5SNmZWY5cjM5IzNlBzMycDOlRTZ0QDOxMjM5IGNxIzYz8CX5d2bs92Yl1iclB3bsVmdlR2LcNWaw9CXt92Yu4GZjlGbh5yYjV3Lc9CX6MHc0RHaiojIsJye.png)
然後客戶又建立了另一個擴充字段B:
Now customer would like to see one more extension field “Special Total Value” whose content is calculated as :
Special Total Value = Quantity * Special Net Price, in the example above = 45 * 100 = 4500 USD.
這個擴充字段B的值是計算而來的,公式是标準字段quantity乘以擴充字段A。
如何實作?
Just create a new Calculated Field in key user tool:
Output: