Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Row Level Formatting on Financial Report (% of Revenue)
I am building our financial reports, specifically an Income Statement.
We want to show our amounts / 1,000 and we don't want to show the decimal.
(Stating the Obvious: I.e. 1,200,000.98 become 1,200).
The problem is that we also want a row to show Income as a Percentage of Revenue.
I can get that, but is a value like 7.9%
Since it is in the same COLUMN as the Amount, and that COLUMN has been defined to Divide by 1,000 and not show decimals)
this row value always shows as 0. I can multiply it by $1000 and it shows something like 790...Not 7.9%
Anwyay to get this row to format differently
0