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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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