NetSuite保存的搜索公式可将其他两列的结果相乘 [英] NetSuite saved search formula to multiply results of two other columns

问题描述

我目前有一个保存的搜索，该搜索填充了一个项目列表. 我当前的结果是标准的NetSuite字段，它们是名称"，描述"，类型"，平均费用"和"可用"

I currently have a saved search that populates a list of items. My current results are standard NetSuite fields which are "Name", "Description", "Type", "Average Cost" & "Available"

我正在尝试为公式添加另一列，该公式将平均费用"乘以可用金额"，以提供可用SOH"的值.

I am trying to add another column for a formula that multiplies the Average Cost by the Available to give me the Value of the Available SOH.

推荐答案

在保存的搜索结果中，添加一个新的字段，其类型为formula(numeric).在公式弹出窗口中，使用以下公式:

In your saved search results add a new field of type formula(numeric). In the formula popup window use this formula:

NVL({averagecost}, 0) * NVL({quantityavailable}, 0)

这会将可用的平均成本和数量相乘，得出结果.我将NVL放在这里，以防某个项目没有可用的平均成本或数量，而不会出错.

This will multiply the average cost and quantity available together and give you the result. I put the NVL in there in case an item doesn't have an average cost or quantity available you won't get an error.

这篇关于NetSuite保存的搜索公式可将其他两列的结果相乘的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！