NetSuite 保存搜索公式以查找两个自定义列的差异 [英] NetSuite saved search formula to find the difference of two custom columns

问题描述

我正在尝试进行保存的搜索，通过确定所有组件是否都有库存来找出可以构建哪些组件.所以我目前在一栏中有这个当 {memberitem.quantityavailable} > 1 时的情况那么 1其他 0结尾与总和汇总类型结合使用.我还有一列选择了成员项目"和一个计数汇总类型.如何制作第三列来计算这两者之间的差异?(我基本上会用什么来表示列名)这可能吗?谢谢！

I'm trying to make a saved search to find out which assemblies can be built by determining if all the components are in stock. So I currently have this in one column CASE WHEN {memberitem.quantityavailable} > 1 THEN 1 ELSE 0 END in conjuntion with a sum summary type. I also have a column with "Member Item" selected and a count summary type. How do I make a third column that calculates the difference between these two? (What would I use for the column names essentially) Is this possible? Thanks!

推荐答案

你应该能够做到:

SUM( [first column] ) - COUNT( [second column] )

并将汇总类型设置为 MIN(使用这种方法，实际聚合发生在您的公式中，但您仍然必须选择汇总类型以显示结果.)

and set the Summary Type to MIN (with this approach the actual aggregation is taking place within your formula, but you still have to select a summary type for the result to display.)

您没有为第二列提供公式，所以我只能猜测您需要的实际公式是什么.如果您刚刚选择了一个字段，则必须将其转换为用于此列的公式.最终结果将类似于:

You haven't provided a formula for the second column, so I can only guess what the actual formula you will need is. If you have just selected a field you would have to convert that to a formula for the purpose of this column. The end result would be something like:

SUM(CASE WHEN {memberitem.quantityavailable} > 1 THEN 1 ELSE 0 END) - COUNT({memberitem})

这篇关于NetSuite 保存搜索公式以查找两个自定义列的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！