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.
NSC | Adding a Variance Column to a Customized Income Statement
Scenario
A user wants to customize an Income Statement to compare two report columns and display the variance between them. This is commonly needed when comparing actuals against budget, current period against prior period, or one subsidiary, department, class, or location column against another.
Solution
To add a variance column to a customized Income Statement:
- Open the Income Statement report.
- Click Customize.
- In the Edit Layout section, click Add Formula Field.
- Rename the formula column based on the desired label, such as:
- Variance
- Variance %
- Actual vs Budget Variance
- Select the applicable Formula Type:
- For variance amount, select Difference (x-y).
- For variance percentage, select
Clarisa De Torres | Ask a Guru
- Earn Community badges now! Refer a Member | Answer Accepter |
The Support Community is your launchpad for learning, sharing, and earning exclusive rewards. Every contribution you make helps others and brings you closer to our official Oracle merchandise.
Learn more and join in the fun:
Tagged:
0