Formula in Netsuite Saved Search

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?

Answers


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.


I think that isn't possible by just saved search.

You will have to group on search result column status, so, all the count total will be based on statuses and you can't write aggregation based on other search results' columns.

you can further write a suitelet/portlet script to use the saved search result and calculate the stats before presenting on UI.


Need Your Help

How would I remove a DIV if there are no IDs using Greasemonkey?

javascript dom greasemonkey

I am wanting to remove two <div>s from a page (hide and collapse the space).

Error in django url.py?

django

I am new in django. I try to practice and run the wiki application (i found tutorial at http://showmedo.com/videotutorials/video?name=1100000&fromSeriesID=110">Learn django), In url.py file i w...