Netsuite 保存的搜索中的公式 [英] Formula in Netsuite Saved Search

问题描述

我这里有问题.在第 1 列中，我计算了所有交易，在第 2 列中，我计算了特定状态的交易.在第 3 列中，我想要 2 以上的百分比；比如特定交易的计数/总数.在 Netsuite 中可以吗?

I have a problem here. In Column 1 I have count of All he transaction, In column 2 I have Count of transaction of specific status. In column 3 I want the percentage of above 2; like count of specific transaction/Count of total. Is it possible in Netsuite?

推荐答案

实际上有一个有趣的功能使这成为可能.具有聚合函数的公式字段在行上有聚合时起作用.因此，例如，如果您想在销售订单搜索中查看状态为已开票的订单百分比，您可以输入公式(百分比)结果，公式如下:

Actually there is an interesting feature that makes this possible. Formula fields that have aggregate functions work when the row has an aggregate on it. So for instance if you wanted to see a percentage of orders with status Billed on a Sales Order search you would enter a Formula (Percent) result with a formula like:

sum(case when {status} = 'Billed' then 1 else 0 end) / count({tranid})

并将聚合应用于该列.该示例使用最大值，但最小值和平均值产生相同的结果.

and apply an aggregate to that column. The sample uses Maximum but Minimum and Average produce the same result.

这篇关于Netsuite 保存的搜索中的公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！