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屋！