Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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