This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is it possible to create a formula based on the count of records? Say CASE WHEN {billingtransaction} &lt;IS MORE THAN TWO RECORDS&gt; THEN 0 ELSE 1 END.

You could do something like this in your summary criteria if grouping results.

Thanks a lot! Is there a repository of functions that can be used with formulas? On the Function field when defining the formula, Count is not available. So maybe there are other functions that I'm missing out that might be very useful. Thanks again!

<@U0147J9JNJ3> There are a lot of functions that can be used that aren't really referenced as a possible selection in saved searches. Suite Answers 10101 "SQL Expressions" is helpful, but still does not contain all possible functions that actually work in saved searches. I use google a lot to search for Oracle SQL functions. Here is a link to a helpful document I was shown when I went to SuiteWorld last year that has helped me with numerous formulas <https://app.box.com/s/fpadf607d7x6muc7wfoas4kpxyc31h0f> . I have this one bookmarked in my browser for easy reference.

<@UHGEJCXTL> great document!! Would you happen to have any others similar to this?

<@U01511V85J7> I don't really have any others like this one, other than random websites that I've found that provide NetSuite help or tips, or of course good old SuiteAnswers :slightly_smiling_face:. There is one site that I visit frequently that provides all around NetSuite tips and sometimes formula related help. Marty Zigman <https://blog.prolecto.com/>

<@UHGEJCXTL> is there a way to use Count in the Standard subtab not Summary subtab? I want to exclude the SO transaction LINES with more than 2 invoices associated. My attempts always result in an error. Hoping that there is way to handle this.

My best work is to exclude them on the Summary results using COUNT in the Summary criteria. However, when there is another transaction line for that same SO with only one invoice associated, the transaction line with more than 1 invoice shows up as well when the detailed results are displayed.

hey <@U0147J9JNJ3>, for your specific requirements, you may be able to get away with a Standard Criteria (non-summary) by using this:
Formula (Numeric), "{quantitybilled}-{billingtransaction.quantity}" is equal to 0

<@UHXHE0684> hey, thanks a lot! It worked. That's a witty solution. I really do need to learn to be more creative.