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!
How Can I Use a "Calculated" Field in another calculation in Financial Statement Columns?
Hi Gurus!
I have a question please as to customizing a financial statement.
High level:
It seems NS can add only existing (eg monthly amount) fields to formulas, and not "calculated" fields (eg, montly difference between this month now and this month last year).
Scenario:
I am customizing an Income Statement.
I have (YTD Now), and (YTD last year) columns.
Then, I calculated column ($ Change) as (YTD Now) - (YTD Last Year).
Then, I want to calculate (% Change) as ($ Change) / (YTD Last Year).
Problem:
I cannot use a "calculated" ($ Change) field for another calculation.
Question:
Do you know how to get around this?