-
Decimal Limit Specification for Percent Field Type
Scenario & Issue: When we input a value with more than 4 decimal places, such as 43.284703%, into a Percent field on a Sales Order and save the record, then the value was saved as automatically rounded to 4 decimal places (43.2847%). Questions: Is it a standard NetSuite specification (Working as Designed) that the Percent…
-
How do I format a formula row as a %
Hello - In the Financial Report Builder > Edit Layout > Formula Row, How do I format the Formula output as a %? I added a GM % formula row calc to a custom income statement but it does not show as a % in results. (Formula is Gross Margin/Rev = GM%) Thanks!
-
Percent Formula of 2 columns on saved search (Est. Gross Profit divided by Income)
How do I write a percent formula to divide Est. Gross Profit (Line) by the Income formula that I have below on my transaction saved search (criteria is Account Type of: Cogs and Income): (fyi: I am using Est. Gross Profit & Extended Cost instead of Profit & COGS since our numbers looked incorrect).
-
Suite Analytics Percent of Total
Hi, I am working in a Suite Analytics Workbook in a pivot table. I thought this would be easy but I was wrong. I am just trying to get a percent of the total or a piece of the pie. So in the screenshot below I would like to turn that count per customer into a percent of the total. So for Walmart at the top would just be…
-
How to add percentage Markup in a Sales Order?
I'm working on repair orders that have addition fees that are a percentage of other lines on the sales order. How can I do this? Here is a quick example: Item a = 50.00 Item b = 150.00 Sub Total = 200.00 EPA Fees(5%) = 10.00 Shop supplies(10%) = 20.00 Total = 230.00 Thank You!
-
How do I retain a % field formatting when I "Set Field Value" for a Long Text Field using Workflow?
I have 2 custom Percent fields I use a workflow to "Set Field Value" for a custom Long Text field. But the field values do not retain the original field format (%). I need the values placed in the Long Text field to be formatted as 100% & 1% but they are simple numbers. Does anyone know what I can add to my formula to…