This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Suite Analytics Workbook : I have two summary groups in a pivot, for Expenses and Revenue.. I want to plot the difference on a line chart. The actual value which calculates the difference is the Pivot's Grand Total row. From what I can see, there's no way to either:
1. Create a custom field which performs calculations on Pivot Row data
2. Create a standard formula field which correctly sums values from different lines.
3. Plot the Grand Total line on the charts.
Is there a cool feature in Workbooks that I don't know about yet?

Also, currency format doesn't seem to work,
Also, Freezing Columns doesn't work when the workbook moves to a custom portlet..

MEH

<@UER9Q3SGM> Have you used these workbooks much?

I ended up creating a different formula field to sum the different types into a single value and then plotted that value on a new chart.

I haven't touched Suite Analytics workbooks at all unfortunately - too busy building customization for folks and not enough searches.

That - and the lack of exportability + the improvements it needs before it is more useful to me than saved searches means I'm far more inclined to keep using saved searches